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:
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 22.214.171.124, 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
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.
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy