Where should relationships be?

[Guest]

Question:
When an application is split with a FE & BE, do you establish the relationship
in the BE mdb. I noticed that even with the linked tables, you can change
the relationships in the FE application. Please explain how this works anyone.

Thank You

Mike Robinson

 

[Douglas J. Steele]

Relationships in the front-end don't do anything: they must be in the
back-end to be of any use.

If you stop and think about it, it makes sense: you can't be sure that
people will always be connecting to the back-end database using the same
front-end.