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 <email@example.com>wrote:
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 188.8.131.52 and MySQL 5.1.55
For unsubscribe instructions e-mail to: firstname.lastname@example.org.**
Posting guidelines + more: http://wiki.**documentfoundation.org/**
All messages sent to this list will be publicly archived and cannot be
For unsubscribe instructions e-mail to: email@example.com
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
Re: [libreoffice-users] Re: Base scenario · Wolfgang Keller
- Re: [libreoffice-users] Re: Base scenario (continued)
- Re: [libreoffice-users] Re: Base scenario · Hank Alper
Impressum (Legal Info)
: 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