>>Hi Fred:
>>
>>Yes that's the correct scenario. But the records haven't been deleted, I've checked after every test in the database tables, only the parent record gets deleted.
>
>Under "Account Configuration" (icon of computer on the left) please check the AutoReply option to quote the previous message.
>
>Exactly how are you trying to do the delete again? I can't follow this thread real well without the other postings.

Hi Fred:
>My code is
>select gisum (parent)
>replace lc_action with "D"
>dele
>currec= recno()
>csessionkey = gisum.sessionkey
>Select gidetail
>
>if !eof()
> lnDelrec= recno()
>replace gidetail.lc_action with "D" while gidetail.sessionkey = csessionkey
>goto lnDelrec
>delete while gidetail.sessionkey = csessionkey
>endif
>go currec
>
>
>
>it finds the correct sessionkey, I notice after it does replace statement it jumps to the
next record or records that I'm looking to delete(i.e. if i have 2 child records I wish to
delete it skips over them, so I used skip -1 to force it back and removed gotolnDelrec
and still not deleting ...!
>
>My primary key in parent(gisum) is sessionkey, this is a regular index in child
>(gidetail)
>
>Such a simple thing and I can't figure why it won't let me delete these records.
>