Re: [libreoffice-users] LO Base Sub Forms

I would suggest you study an application that uses a main and sub form.

I used  the Business Cards example from

 http://forum.openoffice.org/en/forum/viewforum.php?f=100

Good luck





On Tuesday 15 Oct 2013 14:09:59 Ian Whitfield wrote:
> Hi All
>
> I'm still stuck with LO Base Sub Forms!! I've been at this for some
> time, off and on, but over the past few months I have been very busy
> converting, editing and checking/updating my DB to now run on MySQL.
> I must say it is a GREAT improvement!!
>
> OK - My OpSys is PClinuxOS 2012-10. LO 4.1.1.2, MySQL 5.1.55
>
> I have three tables in my DB - 'Members', 'Story', 'eMails'.
> I have one Main Form "Members" (that references the 'Members" Table) AND
> contains a Sub Form "eMail" (that references the 'eMail' Table). Also on
> the Main Form is a Button that should pop-up, over the Main Form, a
> "Story" Form that references the Story table).
>
> All the individual Tables and Forms work well on their own - BUT ...
>
> The "eMail" Sub Form does not "link" to the individual Members record
> and cycle with each record so I can not add info to this Sub Form that
> will be linked with the correct record.
> The Button does not work at all!!
>
> I have worked on this so many times off and on that I'm now rather
> confused on how to go about it or what I did before.
>
> My 'eMails' Table contains the fields - MessageID, Date, In/Out, Title,
> Message. ID (My Foreign Key)
> My 'Story' Table contains the fields - StoryID, Story, ID (My Foreign Key)
>
> If I remember correctly I created the "eMail" Sub Form at the time I
> laid out the new Data Base and under the Button properties I currently
> have "When pressed - Standard.Story.OpenForm (document, Basic)"
>
> Can someone help me out of this mess???
>
> Thanks for ANY help.
>
> IanW
> Pretoria RSA

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted