I searched all over, and found soo many defensive people about why you shouldnt change the numbering, etc. However I have not found a solution to this yet.
I have a waiting list of people. The waiting list is a table that holds information about the people on the waiting list.
There is currently an AutoNumber field. This field is NOT assigned as a primary key, or any key.
There is another numeric field on this table as a primary key.
The people do not get given this autonumber, its simply to use internally so we know who is the next in line.
Occasionally, people get pulled from the middle of the list based on certain criteria.
I am looking for any other creative way to either have a simple number field that gets recounted on every row after a change, or a way to reset the autonumbering.
I need this to be done automatically every time. Would it be better to just have a regular number field, and run some kind of For Each +1 command every time theres a change?
Im trying to not make this overly complex, and hoping that maybe someone knows a trick to make the autonumber just reset, or another simple solution.
Thanks in Advance!!!