AnsweredAssumed Answered

Serial number reset

Question asked by vincel on Feb 19, 2013
Latest reply on Feb 19, 2013 by vincel


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?