Hi Bret ---

Sorry you're having so many problems with this :-) Maybe you're going to have to think about doing a single row TABLEUPDATE() along with the flag manipulation when a row is deleted/recalled.

>
>OK Ingnore the previous message about duplicate record, I found that I did not check the right box for 'SQL Where clause includes' I chose the key fields only option and this fixed the 2 record problem, but it did not fix the fact that the record in the local table is still deleted, even though I recalled it before the tableupdate was done. The data was changed, but the fact that the record is still deleted is the main concern now.