Let me add to what I posted and explain why I designed it that way. There were these testing centers where they would sign in a patient, send him to the specialist, and then to another person who would prescribe a solution. All three were doing data entry on the same record. But, inevitably, someone would not save or save in the wrong sequence and the business process dictated that there were logical steps that had to be worked through where each person should be the only one changing a record at any given time.
>I have experimented with it but the situation hasn't arisen yet to put it into production.....I did a working application with the concept in VFP3 in early 96 that tested out OK but the application was never implemented because the application went client/server before production.
>
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05