I have a FileMaker Server in our office - let's call this Server A. On this server I have a Server Schedule that performs a script in File A.
File A has a data source reference to an external file hosted on Server B outside of the office - this is File B.
The script that the schedule performs on File A navigates to a layout based on a table in File B, finds some records then updates them. This is all works fine during testing with FileMaker Pro as the client. However it's not working when performed as a server side script. I'm trying to clarify whether a server side script on Server A can indeed update records using a layout in the same file that references an external file hosted elsewhere.
Does anybody have any experience with this? If it's not possible is there an alternative method that I can schedule on the server to perform a similar task?