>>
>>select entry
>>locate for entryid = m.lckeyvalue
>>delete
>>
>>select entrydet
>>locate for entryid = m.lckeyvalue
>>delete
>>
>>
>>BTW, what version of Fox is it? Any referential integrity in the database that might prevent you from deleting. Is there any, and if "yes", what kind of relation between those tables?
>>
>>Best regards
>
>thanks for the answer, fox 3 but needs to port seamlessly up to 5.
>Entry is the parent of Entrydet but the 3 rfi rules are all set to "Ignore"
>I'll try the straight delete.
>Sarah
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...
Danijel