We currently have a large database isolated to two of eight departments all contained in one FMP file. With the success we have had using FMP and Server we are planning to continue expansion of our software/database. My question is this... Should all departments operate off the same FMP file, or should be start new files for unrelated departments. Thus having a master database file with menu options to open/load each individual file. Is there any advantage or disadvantage to going about things this way? What have some of you done out there for your large, multi-departmental databases?
I could really use some insight before proceeding (one master file or multiple files)