Re: [libreoffice-users] Re: Base scenario

Ian
How are you defining your primary keys and your foreign keys ? From your
post, it looks like you have two tables, 'Members' and "eMail". Implicit in
your post it appears that the primary key of 'Members' is 'Record ID'.
Also, the primary key of 'eMail' is 'Message ID' while a key called
'Members ID' is a foreign key in the 'eMail' table. I don't see anywhere
that you have specifically designated these keys as primary and foreign
keys. If you defined your tables in MySQL, I imagine you would have to add
the foreign key constraint and designate the primary keys in your
appropriate MySQL table definitions. If you do this, the relationships
window should show a connection between Members.Record ID and eMail.Members
ID. You might try , in the relationship window, to click on Record ID in
the Members table and drag to Members ID in the eMail table.
This dragging method works when using the embedded Database but I'm not
sure if it will transmit the necessary information to the remote database.
Hank

On Tue, Jan 8, 2013 at 9:32 AM, Ian Whitfield <whitfield@telkomsa.net>wrote:

> Hi All
>
> Re - My previous post.... Have been doing some Googling etc and found the
> 'Relationships Window' for setting Relationships.
>
> I can get the Window up, select my Tables but it _DOES NOT_ draw any
> connecting lines or set any Relationships!!??
>
> Is this another "Gotcha" of using MySQL and Base together? As it does
> _NOT_ seem to work at all!!
>
> I'm using PCLinuxOS 2012, LO Base 3.6.2.2 and MySQL 5.1.55
>
> IanW
> Pretoria RSA.
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org <users%2Bhelp@global.libreoffice.org>
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
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