>There are several ways to get autoinc in VFP 6.0. I've had several people question my method that uses FLOCK(), but it has been stressed tested with hundred of users and at multiple locations.
>
Your method makes a lot of sense. You prevent machine #2 from reading and grabbing a lock on a record right after machine #1 finds the record and *doesn't* get the lock. And the file won't be locked long.
Steve Gibson