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