Updateable view not working as expected

[Salbrox]

Hi guys,

Another SQL server issue.

I have a view which consists of 2 tables in a left outer join. This view is linked to my Access frontend (Access 2010, SQL Server 2005). The view should be updateable but when a user tries to add a new record it comes up like this:

#Deleted #Deleted #Deleted #Deleted #Deleted #Deleted #Deleted #Deleted

Across each field in the record.

I tried making the 2nd table in the query a derived table to see if it would work but the same thing happens. The data is writing OK to the first table but it does not show up in the linked view. If i close/refresh the linked view the #Deleted record is gone. i.e. The data entered only shows up on the first table but not through the view.

The idea behind the view is that when a certain code is entered in a field a corresponding date will be pulled through from the 2nd table. Maybe there is a better way to do this?

Any help much appreciated guys!

 

[Salbrox]

Hi guys i resolved the issue. the problem was not what I thought it was. There was a filter on one of the fields in the view which was causing the problem. The new records being entered were being filtered out because the user was not satisfying the criteria of the filter. i set up a default value on the field to counter the issue and everything is working perfectly.