You're welcome.

>That did it. Thanks Sergey.
>
>
>
>>>SET DELETED was already ON, and I'm still getting the deleted record. Thats why I tried
>>>the NOT DELETED(). I'm open to suggestion.
>>
>>You cannot get deleted records with SET DELETED ON unless you're quering not saved buffered data. You either have to save pending changes or add WITH (BUFFERING = .T.) to the query.