Todd,
So it is an updateable view...I was afraid there might be other issues with that.
Does the user also need to be able to recall a previously deleted record?
>Steve,
>
>I just tried a solution almost identical to yours and it displays the deleted records correctly but found it created a reverse problem: it wont delete records in the underlying table.
>
>I added "deleted() as delflag" to my view sql as you described.
>
>In my Save button:
>
>select viewname
>delete for delflag = .t.
>tableupdate(.t.)
>
>Seems to not like delflag as the bound control souce in the check box on my grid.
>
>Im tempted to just add my own logical "delete field" to the table and be done with this. It just doesnt seem that should be necessary...
>
>Todd
Steve Gibson