Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.