The answer is ... it depends. Server can resolve external file references IF the file in question is on the same server. Prior to version ... 10? (someone correct me if I've got the version wrong), the files had to be in the same folder (directory) on the server. So, the short answer is, if you put the files on the same server, it should be able to resolve it (use a file reference of file:filename rather than an explicit path).
Thanks for the response. Unfortuately, the calc field is based on a field in a database hosted on a different server.
Well, there are some other options. You could export the records from database A, use a batch script to move it into the Documents or Temporary directory on server B, and then import into database B.
Or, you could move one of the databases.
Edit: Or go "old school" and use a robot machine.
Just throwing out ideas.
Nancy may be assuming correctly,
Your first question is confirmed. FMS cannot read data from another FMS. It is not a FMP client. There are ways to do it,one is what Mike suggested. Most of the time in order to make it supportable we use a 'controller' (robot) computer that can connect to multiple FMS files and can resolve the file references and do the imports. A looping script or timed script trigger on a layout are two possible scheduling techniques.
You can get this result via the FM Client with multiple hosting servers, but the real restriction is that none of the FM Servers will be able to directly read each other. So if you need info from multiple servers, you can't use Server-side scripting; it has to be run from a Client machine.
Thanks everyone for comfirming this for me.