There are advantages and disadvantages to merging all your tables into a single file. Designers have the option of taking either approach.
Can you please elaborate on the advantages and disadvantages? Thanks
Advantages to all in one file solutions:
Filemaker's accounts and privileges are much easier to manage. With multiple files, you have to set up identical accounts and passwords in each file if you don't want the password log in to popup everytime a user action triggers the opening of another file in the system.
It's harder to "break" a solution by changing the file's name and/or location.
THere's a limit as to how many filemaker files you can have open at one time and you don't encounter that limit if you have one or just a few files to your solution.
Advantages to multifile solutions
If an update is released, only the affected files need be distributed and imports performed. With a data-separation approach, interface updates do not require any data imports. With large files storing 100,000 records or more, this can be a major reason for taking this approach.
Developers can "mix and match" different files as the starting point for developing a solution customized to the needs of a specific user.