I wrote yesterday a question about making a junction table.  I have the data I need to join in an existing table, BUT the ID number for one set of the data is the principal key.  I need to change that ID number.  Seems I can make a new table with the data I need, add a new Principal Key and then alter the ID's in the new table that were the Principal Key in the existing table.  ?

---

Reply from Richard Rost:

What do you mean by "Principal Key?" Is this a PRIMARY KEY or a FOREIGN KEY?