>>>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.
>>
>>Try reversing these two lines:
>>
>>dele all for gidetail.sessionkey = csessionkey
>>replace all gidetail.lc_action with "D"
>>
>>Change to:
>>
>>replace all gidetail.lc_action with "D"
>>dele all for gidetail.sessionkey = csessionkey
>Hi Fred:
>
>I've already tried this...doesn't work, I can't figure out why only
>that it's skipping the records.
Step through the code with the debugger. Make sure you have a "WatchPoint" on the child table values (and RECNO('gidetail')) so you can see exactly what's happening when you do the delete. It still sounds like you have some kind of filter on the child table, otherwise this should work!