table relationships and split dbs

[QB]

I have asked before and now can't find the post (also have a few extra
questions than before) regarding table relationships and split databases.

1. Where should relationships be created? Front-end or Back-End?
2. Do they need to be in both?
3. If you have relationships in the Back-end and then create some in the
Front-End, which take precedance?
4. In the case that they are in the back-end, they will still get
'followed' in the front-end?

I'm sure you get the jist of my question, any explanation to the proper
method of implementing and enlightenments on relationships in split dbs is
greatly appreciated.

Thank you,

QB

 

[Steve]

In a split database, create the relationships that exist between the BE
tables in the BE. They will be effective when you use the front end. If you
create local tables in the FE, create the relationships in the FE. Both the
BE relationships and the FE relationships will be effective when you use the
FE.

Steve
(e-mail address removed)

 

[John W. Vinson]

I have asked before and now can't find the post (also have a few extra
questions than before) regarding table relationships and split databases.

1. Where should relationships be created? Front-end or Back-End?

Relationships should (must) be established in the database containing the
tables; normally this is just the backend. You cannot establish relationships
with referential integrity enforced between tables in different databases.

2. Do they need to be in both?
No.

3. If you have relationships in the Back-end and then create some in the
Front-End, which take precedance?

The relationships in the frontend are merely for display and to provide
default joins on new queries. They won't be enforced, and will not provide any
referential integrity. That is provided by the relationships defined (with
integrity enforced) *in the backend*'; these trump any relationships you
specify in the frontend.

4. In the case that they are in the back-end, they will still get
'followed' in the front-end?
Yes.

I'm sure you get the jist of my question, any explanation to the proper
method of implementing and enlightenments on relationships in split dbs is
greatly appreciated.

Create the relationships in the backend, and ignore them in the frontend,
they're not particularly important there.