** This code is in the click event of the NEW button.
the invsetup lookup table is also in the data environment of the form.

*******
meminv=0
meminvnext=0
&& Get next Invoice/do number

meminv=invsetup.nextinv
meminvnext=meminv
meminvnext=meminvnext+1
replace invsetup.nextinv with meminvnext

******


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