>I need help on this and I hope you can advise.
>
>Thnx
Jeff,
You didn't show the code you use to get the new numbers. Make sure that code locks the record, retrieves the new number, updates the next number and then unlocks the record. The locking and unlocking force disk reads and writes and insure that two users are not retrieving the number at the same time.