Hi,

When I try and update a view entity, I get..

"View or function 'myView' is not updatable because the modification affects multiple base tables"

Is there a way to have two tables from a view updatable?

Cheers,

Ian.

Most databases support by default the update of 1 table using a view. You can work around this by defining an instead of trigger for INSERT on the view