That's a good idea, or just create an Array of record #s and associated User IDs for 'checked out' records, fast and efficient...

Good luck!

>Soft locking works good for me. In this app, there's no reason to have the record physically locked. It's good enough to essentially mark it as being "checked out" by a person. I'm going to try the suggestion from another thread of putting the "checked out" records in another table, which eliminates the need for the extra TABLEUPDATE().
>
>Thanks,
>
>Michelle
>
>
>>We used to do this (SoftLock) in the Fox 2.6 days and haven't been specific at the User-level since, but I am very interested in this thread...I would like to figure a way to do this myself in VFP.
>>
>>The TableUpdate() command will return Record #s for un-updateable records as an Error array, if these could be captured beforehand somehow...
>>
>>Just some thoughts.
>>
>>-Irv.
>>