User selectable remote data source
I have some business application deployments that use filemaker. Recently I've opened a new branch of my business, so I now have multiple deployments for the first time. Basically I'll be deploying the same application twice with seperate data. I've recently been made aware that the best way to do this is by implementing the data separation method in which I'll have a user interface database separate from the actual data. This will allow me to easily deploy the same user interface to multiple locations.
One thing that would make this even easier is if I could configure it so that the user interface database had an easy method with which to select the back end database that it was connected to. This way each front end instance could truely be identical. Is there a method that allows for this to happen but still maintaints the necessary relationships and overall structure?