Referential Integrity - Why can't I make it happen

In relationships I have two table and want them to have referential integrity but the checkboxes are grayed out.  Why is this?
SteveL13Asked:
Who is Participating?
 
Bill RossConnect With a Mentor Commented:
Hi,

You must join on the Primary Key in one table to the same field datatype and length in the other table.  If the fields are different or if one of the fields is not the primary key then there cannot be an enforceable reference between the 2 tables.

Regards,

Bill
0
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
In addition, the two tables must be within the same database container.  You can't enforce RI if their in two different MDB/ACCDB's.

Jim.
0
 
PatHartmanConnect With a Mentor Commented:
Also, you need to create the relationship in the BE where the tables physically reside.  You cannot create relationships from the FE.
0
All Courses

From novice to tech pro — start learning today.