On 04/13/2013 11:29 AM, Ian Whitfield wrote:
Hi All
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
Relations Window)
Press Save
Close Window
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.
IanW
Pretoria RSA
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
having problems.
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.
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
Controls)
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
dialog opens.)
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.
--Dan
--
For unsubscribe instructions e-mail to: users+h...@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
