2 Replies Latest reply on Nov 23, 2011 10:49 AM by johnsimms

    User selectable remote data source

    johnsimms

      Title

      User selectable remote data source

      Post

      Hi There,

          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?

       

      Thanks!

        • 1. Re: User selectable remote data source
          philmodjunk

          Not exactly.

          You can open Manage | External Datasources and edit the file references there to point to different files.

          What you might experiment with is use this tool to list two sets of backend filenames in the relative path format:

          File:DataFile1.fp7
          File:DataFile2.fp7

          What should happen is if you place this interface file in the same directory as DataFile1, it will connect to that file and if you place it in the same directory as Datafile2, it should connect to that one instead. The risk here is that nothing will automatically tell you which file is connected to your external data sources so it might be easy to get confused as to which data file is currently connected to your interface file.

          • 2. Re: User selectable remote data source
            johnsimms

            Phil,

               Thanks for this advice. After experimenting with the external datasources menu, I think this will actually provide the functionality I need. I realized that the menu provides an abstraction since it allows me to name the external source independent from the file name. So, What I'll do is name the source "External Data" then point it to externaldata1.fp7. Then at another location I can just change the file to  "externaldata2.fp7" since the data name stays the same nothing has to change in my design. It would be nice to be able to change datasources within a layout, but this should provide the functionality I need.