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

Reply via email to