Duplicate Values in Index, Primary key or Relationship.

[Deewar]

I am getting the following error, when I try to add an entry in the Query. "Duplicate Values in Index, Primary key or Relationship." I tried finding the duplicate valve but can not see it anywhere in the table. Please, let me know how to fix this.

Thanks.

 

[Remou]

Look at the design of the tables included in the query. Under View->Indexes, you will see which fields need to be unique. Make sure that you enter values in these fields that are not already used.