Most of the databases I have been working with, I have separated into a back-end for data and a front-end for layouts & scripts. I am wondering if anyone has any thoughts on how to properly setup the relationships. Should they all be in the back, the front, or both?

I have found it easier if the relationships and scripts were in the front end using TO from the back end tables.

If you have calculations or data-related or data-dependent operations (such as cascading deletes), there's an argument for having some relationships in the back end to support these.

In my migrated setup, I have relationships in the back end; I have tried to limit them to those that I need for the calc fields to work.

David