Viv, thanks for pointing that out. I made an assumption that I should not have made. Issuing a Delete() does not have to mean the record it was issued to was alive at the time.

And, as you reminded me, issuing 'Delete()' on a live record will set the deleted flag on GetFldState(-1) to '2', but 'Recall' will not set it back to '1'. Only TableRevert() will do that.

Alan

>Hi Alan,
>
>>
>Claude, look up GetFldState() in the help. It can tell you if a record has been deleted before you do the TableUpdate()
><
>
>Not strictly true. GetFldState() can tell you if the deleted status of a record *has changed*. Only DELETED() will tell you it's current state.
>
>Regards,
>Viv