If I delete a record using a query, is there a way to restart auto number to start at 1 and increase in consecutive integers, or is that just going to cause issues with the data?
The autonumber is my primary key and doesn't really have anything to do with the other data in the table (i.e. I don't care if the auto number changes on a record, provided the other data doesn't change).