Error message about duplicate values

[majette97]

How to resolve the following 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.'

We have 2 tables, one for the main form and one for the subform. They a relationship to one another.

What should or needs to be changed in the tables??? Or is there something else that needs to be changed?

Thanks for any assistance!

 

[Jack Cowley]

If the relationship is One to Many be sure that the table that is the Record Source for the subform (the Many side) does not have the index for that field set to 'Yes (No Duplicates)'