I’m looking for what should be a simple thing (at least I thought it was). How do you renumber the record ID field?
It is an auto number field. After deleting records, we have non-continuous numbering which is not helpful for the intended application.
How can I renumber the record ID?