Am a Visual Foxpro beginner with yet another question.. I need you help on again..


I am working on an application that tracks work orders. The work order number field entry is a function of the RECNO() and I want it to be incremented automatically by the program not by the user. I put a default expression for the field in the table structure and also have that field as a Primary index. Well, it seems to be O.K and it's incrementing as I want. BUT this afternoon, I was testing to see what happens when two users opens the database/Table at about the same time to add records. I noticed that both users Work Order No. fields contains the same entries (I suppose 'cos the RECNO() presented to both users are the same). Although they can both have the same values in the wk order field only one can save because of the primary key nature of the field. My problem seems to be how to get different users enter data into the same database with different work order numbers.
any idea???
Please help!!! I would be grateful...