Re: [libreoffice-users] Re: Base; Setting up relations between tables

On 11/17/2013 04:53 AM, Alexander Thurgood wrote:
> Le 17/11/13 06:32, Scott Castaline a écrit :
>
> Hi Scott,
>
> > So how would I do that in the graphical tool? I can't seem to get it to
> > work. I vaguely remember working with foreign keys and the sql statement
> > would refer to AlbumID from the parent as Album.AlbumID for both tables.
> > Wouldn't I also need the ID from the Album table as well? Maybe I'm just
> > better of using SQL Statements, but I don't see where I can do that. The
> > GUI does not seem to be able to do what I am trying to do or I have
> > forgotten more than I thought.
> If you want to use SQL DDL through LO's UI, Options > SQL (or Tools> SQL
> on the Mac) from the main menu is your friend, although the feedback is
> minimal (i.e. you get a message that the statement has executed
> correctly or not).
>
> Other than that, if you are trying to set it up so that your
> Album.AlbumID is referenced in the Track.AlbumID, then the way it should
> work in the GUI is via Tools > Relations in the LO Base file main
> window, adding the tables you want to join, setting the relation as
> 1-to-n by dragging the field AlbumID field from your Album table to your
> corresponding Track.AlbumID field in the Album table and then setting
> the UPDATE/CASCADE/DELTE options as appropriate.
>
> If this doesn't work after saving the database, then that would probably
> be a bug.
>
>
> Alex
Alex,

Within the GUI the steps you describe is exactly the way I had done it. 
When it didn't work, I was trying several different ways, unfortunately 
I didn't track what I had changed in all my attempts so I don't remember 
the alternatives that I tried. I may try using the SQL method as you 
described to see if maybe something between the GUI and SQL is not 
happening.
 Thanks for the feed back.


--
To unsubscribe e-mail to: users+unsubscribe@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