>>Have you got a filter on "NOT DELETED()" on view2 ?
>
>No
I think that's where the problem may lie, you either need the filter (or SET DELETED ON) to get the expected behaviour. One way or another, you've got to stop the SQL for the view returning deleted records from the base table.
Len Speed