No unique index found for the reference field of the primary table."

[jinalpatel]

I am getting this error when I try to enforce referencial integrity from Harvest II table to tractsum table I have attached the relationship diagram. Please give me the hint about possibilities of situation why this error occurs?

Thanks

[RuralGuy]

Does the Harvest II table have a PrimaryKey field?

[jinalpatel]

Yes primary key is Property. It is one to many relationship. One Property can have multiple tract_sum.

[RuralGuy]

Why are there two fields from the Harvest II table in the TractSum table? What is the DataType of these fields?

[NeoPa]

Your attachment doesn't show the details of the link, but I suspect you have no unique index specified for the fields [Property] & [Comp_Tract 1] (taken together as a composite key).

Must they be unique? If so, define the index and you should be able to proceed past that point I would guess.

[jinalpatel]

Thanks you much guys!!
I found that there was no unique index set up for both the primary (composite key - in the table properties) I set that property to yes(with no duplicates) and it gave me another error saying that there is duplicate data in the table. I removed the duplicate data and it allowed me to enforce referencial integrity..Although it is weired that I tried 2-3 time before and it didn't work but finally it works fine.
Thanks much!!

[RuralGuy]

Thanks for posting back with your success.