Relationships in a split database

[Guest]

Hello,

I have a split database (Front-end and Back-end). I would like to know
where I need the relationships created between the tables (front-end,
back-end, both)? Does the front-end respect those created in the back-end or
are they seperate entities?

Thank you,

Daniel

 

[John Vinson]

Hello,

I have a split database (Front-end and Back-end). I would like to know
where I need the relationships created between the tables (front-end,
back-end, both)? Does the front-end respect those created in the back-end or
are they seperate entities?

Thank you,

Daniel

The relationships must be created in the backend, where the tables
are.

Frontend relationships echo those in the backend; any relationships
*created* in the frontend are for appearance only, as they cannot be
enforced (there's no way that relationships defined in the frontend
could prevent someone opening the backend directly, or from a
*different* frontend, or from code).

John W. Vinson[MVP]