I am trying to create a relationship between two tables. Both have data. The relationship is to be one to many from the Key field in the first table to a non-key field in the second table. When attempting to make the relationship, I am getting the error message: “Constraint already exists in statement [ALTER TABLE “People” ADD FOREIGN KEY (“AddressID”) REFERENCES “Property” (“AddressID”)]”
The data in the two tables for the AddressID appears to be the same. The only difference I can find is that the AddressID field in the second table is not set to require an entry. When I try to change it to required entry, I get a different error message and can’t change it.
Any ideas on the problem with the tables relationship?