The error message The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. will be generated by attempting which of the following?
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 in the table Countries with the same primary key as another record.
D) A user tries to request a joined table using the SQL language.

Question

Quizplus · Accepted Answer

The error message is generated when a user tries to enter a record in the table with the same primary key as another record. This violates the uniqueness constraint of the primary key and would create duplicate values. The solution is to change the data in the field or redefine the index to permit duplicate entries.

The Error Message the Changes You Requested to the Table