I have a customer database. Say there are 100 customers entered.

I have 2 (or more) networked users. The app sits with the next Customer # on their screens (101).

How do you usually check if there is any data entered by a user before allowing the other user to save customer 101?

I am thinking of using pessimistic locking if the Last Name field on any computer gets data, then perhaps a timer that would periodically check the record and automatically increment the other user's Customer # to 102???

What would you guys do?

(I'm using VB5 and DAO.)