>This may seem an easy question, but I would like to know this. I have an updateable view, the user lls up the record and deletes it. A save is done and then the view updates the main table. The main table reflects that the record is deleted. Now the user wishes to chnage their mind and recall the record, but when the view runs again the data is shown but there is no indication that this record (1 of 10 in the view) is deleted. Is there a way to have a view return records showing deleted and not deleted records.
>
>TIA

Sure... just add the following column to your view...

deleted() as Deleted

You could display this record some way in your grid with a special background color, or perhaps as a checkbox field or something.

I assume if you undelete (recall) a deleted record in a view, and you tableupdate() it will recall the record in the table.

BOb