You do not need to add a column to the grid for the user to toggle the delete status. There is a delete marker on the left hand side of the grid that you can click on to toggle.
>>The simpliest way would be to SET DELETED OFF, but you can also duplicate the deleted field by adding a new logical field in your table and using that field to toggle the record deleted/not deleted.
>
>I don't like it because to have a consistent interface I have to add a column to all tables that are used in grids. But I think is the only way.
>
>Thanks
kenweber
GCom2 Solutions
Microsoft Certified Professional