Hello I am having a small problem. I have never used databases and only taken 1 course on it in college.
I am trying to use Access to set up a simple database. At the moment I have 2 tables; PERSON, and ACCOUNT. Let's say this is a bank account. The PERSON table has the usual fields, name, address, phone, email, ect.. and an auto number as a primary key. The ACCOUNT table has 3 fields, Account number, Account holder, and Joint holder. Account number is a numbered primary key here.
Both Account holder, and Joint holder I want to have as Foreign Keys from the PERSON table since two people may have a joint account at a bank. Though when I try to create this relationship I get a access cant enforce referential integrity error.
If I have the Primary Key of PERSON as a foreign key in just Account Holder, I get no referential error. Then if I try to add another relationship from the PERSON table to Joint Holder, access says that a relationship from this table already exits and an option if I still want to create the relationship. Upon clicking yes, I get the access cant enforce referential integrity error.
What database rules am I violating here? Thank You for any help.