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 <whitfi...@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%2bh...@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+h...@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
