>At what point does FoxPro commit a record to the table.
>
>I have two users on the network hit the following code at the same time and I am getting duplicate ID's; but two different records.
>
>Select TableA
>Append Blank
>Replace ID with RecNO()
>
>Thank you.
>Neetu
I would suggest implementing a primary key system other than recno(). A tried and true method is to keep a key in another table, call a method to retrieve it (locking the record), and increment it so the next person gets the next number.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown