>>>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.

The question is if the user need to see it before he save it May be not but i agree with you if you want to show what is a auto number may be it's easier if you can show it. Personnaly if you really need continus chain of number {1,2,3,4,5,6,....} I think that's better to generate your number after the save action but if you can live with uncontinus chain number {1,3,4,6,....} show it before save action it's better ...

Rocky Boy...