What is the best way to do this, i need to add a new primary key to stop some duplication i have noticed, so i have created a duplicate table, then thinking i need to clear out the data, set my primary key's, and then paste the old data back - excluding the duplicated files. - This is the bit i am stuck on as the autonumber field is currently the primary key and the number links to the child fields in other tables.
Do i just start again with a new autonumber and then run a query to update the job number on the child fields to the new master number ?
Do i just start again with a new autonumber and then run a query to update the job number on the child fields to the new master number ?