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