double primary keys

[Patrick K]

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

 

[Eugenio]

Patrick K wrote:
>
> I have a table with 2 PRIMARY keys...

Hi,
at the moment DaDaBIK doesn't handle multiple primary keys.

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)