I'm a novice filemaker developer and I'm creating my first database with the data and interface in separate files. I have all layouts, value lists, and scripts in one file and the tables defined in another file. Hopefully this will help make it easier to make changes to layouts and scripts away from my client.

Now my question. Where should relationships be stored? In the interface file or the data file? Or do they have to be in both? Layouts depend on relationships as do tables with calc fields.

Thanks for any tips.

They have to be in both. In the back-end / data-side for the purpose of evaluating calculations and in the front-end for the purpose of scripts / actual data display relationships.

Thanks for the confirmation Genx. I guess I just have to maintain them in each file.

No problem, but out of experience, the front end relationships are more important i.e. they get changed more often because once the data is set up, when implementing new features its mainly reliant on front-end relationships and scripts rather than the actual data it-self.