>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.