External data sources allow you many ways to connect .fmp12 files.
Security becomes a bit of a challenge as files get more interconnected.
Just because it seems odd to have everything in one file does not necessarily make it wrong.
I always work with a data file as a FM database file and many solutions as FM database files.
With FM you can access external SQL, ODBC and Excel databases. You can also do the same in the opposite.