Nadya,
>Thanks again for your help, very appreciate your time spent
>on it. Now, since we found the cause of the problem, it would
>be easier to find a workaround.
You are very welcome, wish I could have been of more help.
You'd better have some good sleep now and look at this when fresh
again (easy to say, I know).
>
>The only problem is that I use related table technique in bunch
>of my applications, so I would have to fix them all...
>
Not necessarily. If this particular one is the only one that
came up, I wouldn't touch the others if they're running well. Maybe
in theese cases the situation is just a tiny little bit different
and that's why they work - never touch a running system. And *IF*
one of the others shows up one day "Record in use ...", You've had
enough time to "train" with this one, so that You know what to do
then.