Updating Linked Table via Form-- HELP HELP (1 Viewer)

Hi All

I'm pulling my hair out. I'm SQL Dev with limited Access Dev. I have an Access Db with a SQL Backend that has been given to me.

In the Access Db, the previous Dev created linked tables to views in the SQL and forms with subforms referencing the view.

I can see why he did a view which combines a static informational table with a manual entry table that needs to link to a record in the information table but my problem is, it works fine if you only join 2 tables since it's a view.

I NEED it to join 3 in the view. When I update the view in SQL, relink the table in Access and try to enter or change a record, I get :

"Update or insert of view or function 'dbo.view_..blah blah' failed because it contains a derived or constant field".

Is there a workaround or trick for this? I was thinking I could just put an update statement for SQL behind each of the fields that needs to get chnaged but I don't know what event I put that in.

Argghh..I've been trying to figure this out for 2 days...

Anyone have to work with this before?

Thanks!