Background documentation-8035: Foreign key must exist Locate this document in the navigation structure

 

Explanation

An UPDATE statement was issued on an updateable join view table. This UPDATE statement leads to an internal insert into one of the underlying base tables. The specifications made in the UPDATE statement are not sufficient to form all mandatory columns which are needed for the implicit INSERT statement.

User Response

Issue an INSERT statement on the underlying base table. This can prevent the necessity of inserting when performing the UPDATE statement on the join view table.