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

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.

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.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.