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: [email protected] 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
