Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

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?
0
SteveL13
Asked:
SteveL13
3 Solutions
 
Bill RossCommented:
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)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
 
PatHartmanCommented:
Also, you need to create the relationship in the BE where the tables physically reside.  You cannot create relationships from the FE.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now