I am trying to set the relationship between two tables. One is a list of court jurisdictions that has a key field that is an AutoNumber field. A second table is a list of judges. I am trying to link the two in a one to many relationship.
When I link the Jurisdiction field in the Judges table to the Key field in the Jurisdiction field it will not let me enforce referential integrity. It gives me the error message that is the subject of this question. The jurisdiction field in the Judges table is a text field. I thought that might be the problem, but:
- it cannot be an AutoNumber field and
- I can't change it to a Number type even though I have deleted the relationship. When I try, I get an error message telling me to delete the relationship, but I already have done that.