Relationships in a split database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top