Share via

no unique index found for the referenced field of the primary table

O'Donnell, Sharman@DIR 0 Reputation points
2024-09-10T17:49:46.9566667+00:00

This error pops up during creation of relationships "no unique index found for the referenced field of the primary table"

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
876 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,501 Reputation points
    2024-09-10T17:55:22.0533333+00:00

    no unique index found for the referenced field of the primary table"

    As the message clearly say, no primary key nor unique index = impossible to create a relation shop.

    Create a primary key on the to referenced table first.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.