2 Replies Latest reply on Jan 14, 2015 1:25 AM by imitch

    Accessing a Filemaker database external data source on a server (A) from a filemaker database on...

    imitch

      Summary

      Accessing a Filemaker database external data source on a server (A) from a filemaker database on another server (B) via WebDirect

      Product

      FileMaker Server

      Version

      13.0.5/13.0.4

      Operating system version

      OS X 10.9/10.8

      Description of the issue

      We have two filemaker servers, the first one (RemoteServer) hosts 95% of our organisations Filemaker Databases while second (WebServer) hosts a filemaker solution that is accessed through the web browser.

      We realised that a database on the WebServer, when accessed via web direct cannot access any linked databases on the RemoteServer.

      Steps to reproduce the problem

      1. Host RemoteServer.fmp12 on one server (RemoteServer)
      2. Host WebServer.fmp12 on a second server (WebServer)
      3. Enable Webdirect on both servers and databases
      4. Create a local account on each database with the same username and password.
      5. Create a table Warehouse (id, name, location) in RemoteServer.fmp12 and add a couple of records
      6. Create a table Product (id, name, warehouse_id) in WebServer.fmp12.
      7. Add RemoteServer.fmp12 as an external datasource to WebServer.fmp12
      8. Create a table occurrence of Warehouse in WebServer.fmp12 and do a relationship between the two tables using Product.warehouse_id = Warehouse.id
      9. Go to the Product layout and add all the fields from Product and Warehouse tables.
      10 Create a new record in the Product table and enter a Product.warehouse_id value from the ones you created in step 5. You should see the corresponding Warehouse name and location values.
      11. Open WebServer.fmp12 from the browser via webdirect, and you will notice that the fields from the Warehouse tables have in them.

      Expected result

      I expect to see the corresponding Warehouse name and location values, similar to what happens when WebServer.fmp12 is opened in FilemakerPro

      Actual result

      When WebServer.fmp12 is opened from the browser via webdirect, and you will notice that the fields from the Warehouse tables have in them.

      Exact text of any error message(s) that appear

      Workaround

      Create duplicate tables in WebServer.fmp12 and schedule daily import from RemoteServer.fmp12

      fmserver13_issue.png