>>

select entry
>>delete from bkdata!entry where entryid = m.lckeyvalue
>>	
>>select entrydet
>>delete from bkdata!entrydet where entryid = m.lckeyvalue
>>	
>>=requery('ventry')
>>thisform.pgfEntry.pagPick.grdEntry.refresh()

>>
>Hi, Sarah
>I haven't had much time to think about your problem. but since it's a hurry I thought I'd come with the first thought I came across, namely to delete the record in another fashion, the way I use to do. I never had any problems, so it might be worth a shot.
>

>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