CODEWITHSUNDEEP
sqldatabasems-access
Lime3003
Lime3003

Reputation: 123

Access database two primary keys

I have two primary keys in one table that should be in a relationship with another table. So I should have two foreign keys in that table but I can´t get it working. Because it´s says "No unique index found for the referenced field of the primary table." When I try to connect them.

Upvotes: 0

Views: 1232

Answers (1)

Marichyasana
Marichyasana

Reputation: 3154

Just change one of the columns to not be a "key" rather make it "unique" ("unique" is mentioned in the error message you are getting.

Upvotes: 1

Related Questions