>Shafid,
>
>You can use a record lock to insure the barcode number is not duplicated. Example code is below (untested just use as an example).
>
>

>LOCAL lnBarc
>SELECT barcno   && table with barcode number
>IF Barcno <= 0
>   MESSAGEBOX("This computer is not setup with barcode numbers","")
>   RETURN
>ENDIF 	
>DO WHILE NOT RLOCK()
>ENDDO
>lnBarc = Barcno.Barcno  
>REPLACE Barcno WITH Barcno+1  &&increase by one
>UNLOCK
>

Is it possible that another user would not see the updated value after you've done that or will everybody having the table open get a refreshed version when the lock is released?