Accessing a Filemaker database external data source on a server (A) from a filemaker database on another server (B) via WebDirect
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
I expect to see the corresponding Warehouse name and location values, similar to what happens when WebServer.fmp12 is opened in FilemakerPro
When WebServer.fmp12 is opened from the browser via webdirect, and you will notice that the fields from the Warehouse tables have
Exact text of any error message(s) that appear
Create duplicate tables in WebServer.fmp12 and schedule daily import from RemoteServer.fmp12