I have written a small team CRM for my mortgage branch that others want to use, via client-server pointing to my server.
But,we need to keep all data TRULY separate, NOT just tagged as "client X's contact"
Of course, the solution has tons of scripts, tables and a few external file sources.
If I was programming in Coldfusion, I'd simply have a startup script that pointed to each users personal database, as the presentation and logic layers would be completely independent.
What is the correct Filemaker way of keeping the data tables separate and not killing oneself trying to maintain the logic and presentation layers when making tweaks?