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

I haven't worked with SQL DBs since the late 80's so I'm not sure what 
I'm doing wrong here. I have created a BASE DB using the internal HSQLDB 
engine for my music collection containing different media (CDs, DVDs, 
Vinyl LPs, 45s and Cassette, wife had thrown out all my 8-tracks back in 
'98 as well as my Reel-to-Reel tapes :=( ). I created the main table for 
Album Info using a field that is auto incremented (essentially record 
id) integer type, the first field and set as the Primary Key. I then 
went to create another table (Tracks child of Albums) with TrackID as 
the first field and Primary key, AlbumID, AlbumTitle, TrackNumber, Track 
Title, Artist, Time, & Note set as Memo. When I went to set the 
relations I picked the child table 1st and then I added the parent table 
using the AlbumID as the field to link. It won't do it. I had it working 
a few days ago the first time I did this, but when I went to upgrade 
from Fedora 20 Alpha to Fedora 20 Beta I didn't realize that my backup 
of the original DBs didn't work so I had to start over. I thought that's 
what I had done originally when it worked, but apparently not.

So what should I be using to set the relations between child and parent?

Scott C

--
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