Relationship problem

[avagodro]

I have a backend and frontend database. The backend database I am using as a "centralized" database for some aspects, such as employees, which I want in all of my databases.
When I create a link to the table in my frontend, and attempt to create a relationship, I have noticed that the Enforce Referential Integrity option is greyed out. Is there any way to have Referential Integrity between linked tables?

 

[jebry]

Hi!

You can only create relationships like that in the back end where the tables actually reside.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst