Location of relationships 1

[wm2005]

I have two backend database MDB's on a network being accessed by multiple MDE frontend applications.

The data in the two backend MDB's relate to each other. So I have had to setup the relationships in the frontend app. But of course the tables linked from the two different databases wont establish an enforced relationship.

So how do you think I should setup the relationships for all my backend tables...

- just in the frontend (as it is now)
- in both frontend mde and backend mdb's (mirrored)
- only in the backend (with local table relationships)
- only in the backend (with linked tables from the other mdb)

Your thoughts most appreciated,
Will

 

[lupins46]

Each backend database should have its own local relationships established with RI enforced where applicable.
These will be enforced through any front end processing.

Any relationships you set up in the frontend between tables in different backends are essentially documentation, although they will be applied when you use the query grid. As you say, you cannot enforce RI between tables in different source files.

 

[wm2005]

Thanks Lupins.