Hi,
I work for a business and we are setting up our database. We created all of our records but somehow duplicates for every record were made. Now it seems that the best way to eliminate this problem is to create a script based on each record's Unique ID.
Unfortunately we did not create any Unique ID's when we built the database. I went in and created a new field to be Auto-Enter with a Serial number but it did not generate serial numbers for the current records (the field is there, but it's empty).
How can I have this be retroactive for all records in the database? Or, is there an easier way to get rid of multiple records that doesn't involve deleting them one-by-one (we have thousands)? Answers to both of these questions would be much appreciated. Thank you.
