Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Trouble creating a relationship between tables. Error message SQL Status: S0011 Error code: -60

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?