Establishing Referential Integrity between Tables - No Unique Inde

[Guest]

I have a number of parent - child tables for which I need to establish
referential integrity. Here is an example:

Parent table: UC Requirement
Key fields: UC #, Release, UC Name, UC Status

Child related table: UC Entity
Key Fields: UC #, Release, Logical Entity

I have joined the two tables by UC # and Release in the relationships.
Where I am trying to create a one to many relationship, it is noted as
indeterminate. When I check the Ref Integrity box, I receive an error
indicating "No unique index found for the referenced field of the primary
table".

I have run the Find Duplicates and Find Unmatched queries to ensure the data
is not the issue.

Can you help to determine what I am doing wrong?

 

[Guest]

hmmm well; a possibility on that error message is that there is a duplicate
buried in the table from past ages or possibly even data that doesn't conform
with the currently defined format. or empty records? ...very much a guess
though on my part. you might just sort the column in question in table mode
of both tables and do a quick visual scan down the column if at all
feasible....you never know something obvious might pop out.

a good chance others will throw better suggestions on this. in the interim
you should be still able to move forward setting up your DB, forms, etc.....