On 04/13/2013 11:29 AM, Ian Whitfield wrote:
You are using Base with MySQL. Tools > Relationships opens the
Relation Design dialog. You can use this dialog if you have an embedded
database but not when connected to a MySQL server. That is why you are
There are 2 ways to define the relationship between a form and its
sub form: Tools > SQL, and edit the form, itself.
1) Tools > SQL: For this you will have to read your MySQL user
manual to see how to define the foreign keys using SQL. (It is probably
similar to how the HSQLDB user guide says you should do this.) Perhaps
you could get the information from "Base Tutorial" by Mariano Casanova.
It discusses how to use Tools > SQL.
You will have seen my question to Noel about Relationships and his reply.
I just tried again as he suggested ...
Open Relationship Window.
Add my two Tables
Click on 'New Relationship' (There are no fields listed)
Select "id" in Main Table
Select "id" in Second Table
Press Close (Window does NOT close so press 'X' to close it)
(There are NO lines or any other change to the Tables display in the
Press Save again
Open Main Form
But I'm afraid the sub-Form does _NOT_ work still!!
Can anyone see the error I can't see??
Thanks a lot.
2) Edit the form:
a) Open the form in Edit mode.
b) Click one of the controls in the sub form.
c) Open the Form Controls toolbar. (View > Toolbars > Form
d) Click the Form tool to open the Form Properties dialog.
e) Click the Data tab.
f) Link master field: Click its ellipse. (The Link fields
g) Select the foreign key of the sub form table in the left
drop down list.
h) Select the primary key of the main form table in the right
drop down list.
i) Click OK closing the Link fields dialog.
j) Use the ESC key to close the Form Properties dialog.
l) Save and close the form.
For unsubscribe instructions e-mail to: email@example.com
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