>When they are done working with the record, I just update that field and set it empty.
>
>Kirk

What if there is a power outage, exception in the application that causes an unexpected exit, or some other unexpected event? I think you are running the risk of locking records that shouldn't really be locked.