Serial number reset
within my database I want to have record numbers so i've created a field called "Line Number." I've set it up to auto enter with next value being "1" and increments of "1".
The problem I'm having is that users are using the same database over each time they use the database. They just delete the records but then the "Line Number" continues to move foward.
Is there a way to rest the starting value with a script that the user could hit as a button to make thing easy?
Or is there another way to use record numbering than i'm using?