Ravi,

I'm doing OK. How are you doing?

You need to tableupdate() on TableA. If you don't, a SELECT statement on that table will still retrieve the record you have deleted.

delete from TableA where TableA.IDNumber = mIDNumber
llStatus = tableUpdate(0, .t., 'tableA')   && current record
if !llStatus
    * you were not able to delete the record
endif

>Hi again Steve:
>
>How are ya> Thank you for responding.
>
>>is there buffering on TableA?
>
>Yes. This is in the Init() of FormA
>