Hi there,
I'm having a hard time wrapping my head around this Referential Integrity stuff when creating relationships between tables. I'm stuck and hope someone can help me.
I'm dealing with three tables: EMPLOYEES, EMPLOYEE_STATS, and LOCATION
The fields beak down like so:
EMPLOYEES
EMPLOYEE_ID (primary key and indexed)
FIRSTNAME
LASTNAME
EMAIL_ADDRESS
EMPLOYEE_STATS
EMPLOYEE_ID (primary key)
EMPLOYMENT_TYPE
TITLE
LOCATION
EMPLOYEE_ID (primary key)
DIVISION
SECTION
CIVIC_ADDRESS
CITY
POSTAL_CODE
FLOOR
Ok...so I'm able to create a one-to-one relationship with Referential Integrity between the EMPLOYEE_ID in EMPLOYEES to the EMPLOYEE_ID in EMPLOYEE_STATS tables. But when I attempt to do the same thing between the EMPLOYEE_ID in EMPLOYEES to the EMPLOYEE_ID in the LOCATION table I get Access telling me that:
"Data in the table LOCATION violates referential integrity rules....yada, yada"
What am I doing wrong and how do I fix it?
Please advise,
Alan