If a form presents a parent row and a child in...let's say....a grid you can protect a record from being used by others (parent) but still only expose those child records applicable for insert or append because other users cannot mess with the children when mommy and daddy are unavailable. In theory :)
>Eeeeew! What am I missing? The parent table row is locked the entire time you fiddle around with the child? Seems *better* to use optimistic and transactions...
>
>>Soemthing to think about: Pessimistic row buffer the parent table but optimistic table buffer the child....think about it :-)
------------------------------------------------
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