UNION and Unique ID

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have duplicate records in my database that I would like to keep and assign
a new unique ID to. Do I need to reassign all records to have new ID's? Do
you have sample code?
 
Just appending them to a table with an autonumber pk included would be one
way. The other would be to use some code (I think that would be easier than
using pure queries) to check for duplicates and assign slightly modified
(i.e. ID+"A", ID+"B") ID values.
 
Back
Top