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 -- To unsubscribe e-mail to: [email protected] 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
