3 Replies Latest reply on Nov 20, 2012 5:17 AM by Mike_Mitchell

    Sharing table with multiple FMP12 application




      Is it possible to have a FMP12 application file's table be available for another FMP12 application? Is it possible to do this without manual import/export?





      I have one FMP12 application (app1) that does the front end data collection input and stores the data in its table.


      I have another FMP12 application (app2) that reads the app1's table, and perform data-mining, reports generation etc.


      I am planning to run these two apps using FMP Server edition.

        • 1. Re: Sharing table with multiple FMP12 application

          Hello, fmk4.


          Yes, certainly you can reference data stored in one FileMaker file from another. You can do this a couple of ways.


          The most direct way is simply to add a table occurrence (TO) to your relationships graph that refers to the other file. Here's how:


          1) Go to File > Manage > Database.

          2) Choose the Relationships tab.

          3) In the bottom left-hand corner, click the "Add Table" icon:   addTable.jpg

          4) When the "Specify Table" dialog appears, choose "Add FileMaker Data Source" under "Data Source":


          5) Follow the path to the FileMaker source. (Use the "Remote" button to point it to a file being hosted on Server.)


          The other method would be to add the data source manually. Here's how:


          1) Choose File > Manage > External Data Sources.

          2) Click "New".

          3) In the "Edit Data Source" dialog, give the data source a name (typically, the name of the file) and then click "Add File" (to point it to the file you want to add).




          Then, add the TO to your Relationships Graph as you need to.





          • 2. Re: Sharing table with multiple FMP12 application

            Hi Mike,


            Thanks for heads up!


            So, if I update the table in app1, app2 will get the updated data in real time?