DB Relationships

  • Thread starter Thread starter evelyn.felix
  • Start date Start date
E

evelyn.felix

Database is broken into two, one is a Backend (tables
only), the other is a Frontend (query, forms, reports,
macros, etc.)

In the backend, the relationship between two tables shows
One-To-Many, enforce integrity, etc.

In the frontend, the relationship between the two tables
shows One-To-Many (External), everything is greyed out.

In the frontend DB, the tables are linked.

Shouldnt the frontend mirror the backend?

I'm confused. Can anyone help?
 
Evelyn,

Once you have set your relationships between tables in the back-end of your
database, you do not need to reproduce or mirror those same relationships in
the front-end of the database.

You can only set the referential integrity properties of related tables in
the database in which the tables are stored, which is why those options are
unavailable when you are setting the relationships in the front-end.

hth,
 
Back
Top