Wise you are, Master Yoda!

In mysql, I used:

ALTER TABLE `artistsProducts` DROP `artistProductID`

ALTER TABLE `artistsProducts` ADD PRIMARY KEY (artistID,productID)

And viola! That is now my primary key. Thank you very much! I search high and low on the web, but couldn't find answers, and here I got lots of help. Cheers!

While when playing Star Wars Knights of the Old Republic, I am Sith, when programming I aspire to the light.

(If a gamer Yoda be, Knights of the Old Republic 2: The Sith Lords come out today it does! Young Jedi Dave first must finish freelance work, sadly.)

- Dave