Autonumber settings

[Pat Hartman]

When you use a table to assign numbers, you can still end up with discarded numbers if a user starts an action, gets to the point of assigning the "next" number, and then cancels the action. This has the potential to create a gap which is most people's issue with autonumbers. The only solution is to wrap the whole process in a transaction which assigns the new ID and locks the ID table in the process and doesn't release the ID table until the new transaction is complete.

 

[neileg]

Thanks forthat, Neil. Can you post the page ref so I can look it up tonight.

Post 3 in the thread I linked. From Dennisk.