In a 1-M updatable query,to insert a row into both the parent and child tables,you must supply the primary keys and all the required columns of both the parent and child tables.

Question

Quizplus · Accepted Answer

This is because you cannot insert a row in the child table without first inserting a row in the parent table, and to do so, you must supply the primary key of the parent table. Additionally, you must supply all the required columns of both tables to ensure data integrity.

In a 1-M Updatable Query,to Insert a Row into Both