bdonelson Posted August 2, 2006 Share Posted August 2, 2006 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? Link to comment Share on other sites More sharing options...
Breezer Posted August 3, 2006 Share Posted August 3, 2006 I have found it easier if the relationships and scripts were in the front end using TO from the back end tables. Link to comment Share on other sites More sharing options...
T-Square Posted August 3, 2006 Share Posted August 3, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6476 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now