Script to renumber auto number field

[Johnny777]

Hi

Not sure if this is the right part of the forum.

I have a table with a record_ID field which is a unique number using the auto-enter facility.

I have managed to create a number of records with duplicate numbers, (not sure how - but almost certainly when I was transferring stuff from an old database). I need to renumber all the records so that they have unique identifiers. The table does not have any related records at present so will not cause any problems renumbering.

Many thanks for reading

[comment]

1. Show All Records

2. Unsort

3. Click in the record_ID field and select Records > Replace Field Contents… > Replace with serial numbers (with update).

[Johnny777]

Sorted

Many thanks for reply