P
Patrick K
Guest
I have a table with 2 PRIMARY keys...
It is a table that keeps track of songs per album
I have three variables:
album
song
trackumber
album and songnumber are primary keys...i have done this to keep me from entering more than 1 track #5s for example.
this seems to trip up DaDaBIK...I can enter new records but when I go back edit fields the wrong information comes up...
For example if I have album=depechmode
song=masterservant
tracknumber=1
and then go on to enter several more tracks on the same album...
even if I try to edit the record for track number=7...it shows the data to be
the same for tracknumber=1...
Is this because I have no autoincrement primary key such albumID???
It is a table that keeps track of songs per album
I have three variables:
album
song
trackumber
album and songnumber are primary keys...i have done this to keep me from entering more than 1 track #5s for example.
this seems to trip up DaDaBIK...I can enter new records but when I go back edit fields the wrong information comes up...
For example if I have album=depechmode
song=masterservant
tracknumber=1
and then go on to enter several more tracks on the same album...
even if I try to edit the record for track number=7...it shows the data to be
the same for tracknumber=1...
Is this because I have no autoincrement primary key such albumID???