To add a little more to the problem. As explained to me the first used entered submission number 4274,4275, and 4276. A short time later another user entered a submission and it assigned it 4275 and the next 4276. Appears the table was never updated for the first user.

Thanks Gaylen



>I use the following code to create sequential numbers compliments of Michael.
>The code has worked fine until the last several days where it is creating duplicate numbers.
>
>

>LOCAL lnOldSel,lnCompteur
>lnOldSel=SELECT()
>lnCompteur=0
>IF ! USED('key_no')
> USE key_no IN 0
>ENDIF
>SELECT key_no
>1
>DO WHILE (NOT RLOCK()) AND (INKEY(0.1)=0) AND lnCompteur<=25
>   lnCompteur=lnCompteur+1
>ENDDO
>REPLACE NUMERO WITH NUMERO+1
>UNLOCK
>SELECT(lnOldSel)
>RETURN key_no.NUMERO
>
>

>
>The server is Windows 2000 server and using VFP 7.0.
>
>
>Any idea what may be happening or is there an inherent flaw in the code.
>
>Thanks
>Gaylen