You can do it in one file with a multiple line external data source reference; or two sparate references, and the script checks one and then the other. I like the later option as it is a little more transparent to debug.
Note that FMP looks really hard for a file, so a missing reference will slow down the opening. I'd check for the local LAN file first, and then the WAN.
The script could simply be an If/Else. If: Opening the LAN file works (no error)/Else: Open the WAN file.
Hope this helps. Post back if not clear enough.
Thanks for the information. I will give it a try and reply back if I run into problems.
Have a great weekend.
If your LAN-connected computers use a specific range of IP addresses, you can have the script run an IF test on the pattern count for the consistent part of the current IP address, then perform the open file or perform script step on the correct data source. This allows keeping the paths in separate data references, which is faster than having stacked/multiple paths in a single data reference.