>How do I make a view exlude the deleted records from within the view designer?
>
>Paul

You can use the DELETED() expression in the SQL statement, but this doens't work if the view looks at more than one table.

The usual way to do this is just make sure that SEt DELETED is ON before you requery the view. Remember that SET DELETED is scoped to the current datasession.