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

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.

On Tue, Jan 8, 2013 at 9:32 AM, Ian Whitfield <>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 and MySQL 5.1.55

Pretoria RSA.

For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
org <>
Posting guidelines + more: http://wiki.****
Netiquette <>
List archive: 
All messages sent to this list will be publicly archived and cannot be

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.