The error message You cannot add or change a record because a related record is required in table 'Countries'. will be generated by attempting which of the following with the Megacities database?
A) A user tries to enter a record in the table Countries that doesn't contain data in the primary key.
B) A user tries to add a record to a table that is related to the Countries table, and that record contains a foreign key value that does not correspond to a primary key value in the Countries table.
C) A user tries to enter a record to the table Countries with the same primary key as another record.
D) The user tries to request a joined table using LINQ.

Question

Quizplus · Accepted Answer

The error message is generated when a user tries to add or change a record that is related to the 'Countries' table, but the foreign key value does not match a primary key value in the 'Countries' table. This indicates that the 'Countries' table must be updated first before any related records can be added or changed. Option A and C involve primary key constraints whereas the error message is related to foreign key constraints. Option D is not related to the error message being generated.

The Error Message You Cannot Add or Change a Record