Update or insert of view or function 'vw_item_container' failed because it contains a derived or constant field.

Hey Timothy,

Views compile their data with potentially more than one table as their source of information. That means that when you're trying to add a record to a view, the application does not know where to leave this information exactly.

If you want to insert data into a view or update the data in a view, you will have to add an instead of trigger to this view that contains the specified insert statements. More information on instead of triggers can be found here:

• https://docs.thinkwisesoftware.com/docs/sf/business_logic#trigger-/-event
• https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/

Hope this helps!