Hey Chuck (nice name!)

VFP does not natively give you this ability. You will have to find if someone else has written the code in order to do this.

I have thought this idea through a bit, but never implemented this idea myself. Here's what I think it would entail, however:

You must employ your own locking mechanism in addition to using RLOCK. Basically, instead of calling RLOCK directly, you call a custom function. That function would issue an rlock, change a special field in the record to show that the record is locked and by whom, and then unlock the record. You MUST use RLOCK because without it, you may be looking at an old version of the record, cached locally. RLOCK forces the local cache to be updated.

Someone must have code for this... anyone??