I have a data separated solution with multiple data files. My user data is in it's own file so that it can be referenced by multiple solutions.
Through the "DatabaseNames" function, I've discovered that PSOS sessions don't always open the users file, which causes plenty of other issues when trying to reference data in the external data source. Since the "Open File" script step isn't supported on Server (Open File Help Doc), how can I force FileMaker to open the file?
I've already tried navigating to a layout based on a Table Occurrence in my Users file, but it just returns 0 records. Any suggestions?