Hi:

Still not deleting child records....

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.

What am i missing?????