On 01/30/2014 02:44 PM, Dan Lewis wrote:
On 01/29/2014 09:36 PM, Mark LaPierre wrote:
I've been struggling with this for weeks. I've got the Base Handbook
for Version 4 that goes along really well with the version 4 LO that I
have on my system. I also purchased a copy of "OpenOffice.prg Base &
Basic" that contains lots of really good information.
I'm trying to build a recipe database. I have several tables, one that
contains the name of the recipe, another that contains the instructions,
another for the ingredients, and so on. To display the entire recipe on
one form I need data from more than two tables.
I've found a way to insert a subform that contains data related to a
table that is different from the table related to the main form, but I
still need data from several other tables to complete the display. The
problem is that I can only find a way to insert one subform.
Now that the scene is set I'll ask the question. How can I pull data
from several tables, that would be more than two, on one form? Is there
a chapter in the Base Handbook that I need to read more closely maybe?
What I would do is create a form using the form wizard containing
the main form and one of the subforms. When this is done, edit the form.
(Right click the name of the table and select Edit from the context
menu.) Then you will need to to add the Form Controls toolbar (View >
Toolbars > Form Controls). On the right end of this toolbar are tools
that open the other two toolbars you will need: Form Design and More
Controls. From the Form Design toolbar you begin by opening the Form
Navigator. It is this tool that enables you to added additional subforms
and define the relationships that exist between the tables used in the
I am finishing the "Tables" chapter for the Base Guide. So it is
only a draft copy and will contain notification of such. If you would
like for me to send you a copy of it, I can do this Saturday morning. It
is approximately 700KB. It contains details on how to create a form
containing multiple objects (Tables, Views, and Queries.) There are
screenshots of the tools to help you.
This sounds like just what I'm planning to do. Feel free to send me the
file. Is it on ODF Authors? I can pick it up there if you send me a
link to it.
^ ^ Mark LaPierre
Registered Linux user No #267004
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