Okay, I think I'm catching up <s>. IOW, if you pessimistically lock the parent table, then the children are...What? Another user can't change the parent that you have locked, but they could change the children, could they not?

>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.
>