Then I guess you'd have to find some other way to accumulate the records for display in the Grid and manipulation by the operator. Like a CREATE CURSOR and a SCAN/ENDSCAN to fill it up.
Alternatively, as i think you've mentioned, you could have your own logical field for the purpose.

I think the crux of the matter is 'should SQL result sets include the deleted flag ON or not' and I think the case for not is a reasonable one. For instance, SQL Server does NOT have a deleted flag, and when you delete there it is gone for good.

cheers
>Jim,
>
>What if you wanted to use that result set in a grid with a check box in a column for the operator to delete and recall records?
>
>I know you could use the delete flag as part of your query and just display deleted/not records in your dataset. In this case I need both displayed, therefore, how could the operator know which records had been previously deleted when the delete flag magically disappears?
>
>Todd