>>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.
>
>Sorry, I should have said, I have got SET DELETED ON, I just haven't got it filtered in the view.
>
>Kev

One last shot here, (I'm pretty much out of my depth as it is - but I need to understand this myself) - have you got buffering on for the base table as well as the views. Without buffering on the table, I get the expected results, with buffering on the table, I also need to do a tableupdate on the table as well as the views for the requery to update the views correctly.