If I remember correctly (and I have not looked at this in a while), I
think that you need to link the "master and slave fields".
So, if you open your form in edit mode, load the form navigator, right
click on your sub-form and choose properties, navigate to the Data tab,
do the values in the "Link master fields" and "Link slave fields" look
right to you?
On 10/15/2013 08:09 AM, 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
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
--
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
