Re: [libreoffice-users] Using a Button to activate Subform. Relationships

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+help@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