>>I am trying to have new records AUTO NUMBER. My method
>>is to index on a unique number field and add one number and that is the new number for the next record.
>>Having problems like this...
>>the first user adds a record and the computer issues a number 3, at the same time the second user adds a record and the computer issues a number 4. Then first user decides to abort and the second user saves.
>>Now the second user has the number 4 for it's AUTO NUMBER and there is not a number 3 because the first
>>use did not save. How can I best do a AUTO NUMBER system?
>
>Hi Robert,
> I don't know if i really undestood but why you don't wait for the (save) confirmation before to go get your next number ?
>
>
>Hope this help if not May be next try ...
>Rocky Boy...

Good question... I want to show the user what their AUTO NUMBER will be.
Do you think that is a good idea? Maybe, that is not important to show the user their AUTO NUMBER and they should only see it after they have added the record. What do you think.