>>>
>>>select entry
>>>locate for entryid = m.lckeyvalue
>>>delete
>>>
>>>select entrydet
>>>locate for entryid = m.lckeyvalue
>>>delete
>>>
>>>
>
>Exactly my point. You should delete record in the child table first, then parent (I know, you have "ignore" in your rfi rules, but still a nice habit, don't you think?). And yes, Fox 5 sounds like a natural way to go, even Fox 6, but I haven't done that either...
Right, the child goes first... all the rfi's are gone but still no joy. Is it because the view is open, surely not, otherwise we wouldn't have requery. This has me stumped. Still it's late in NZ so maybe that's it...
- love the quote and bubbles
Sarah King
pcpropertymanager.com