If i remember right ExecuteSQL of data in the remote file will return ? if the remote file is not available.
I use BE_FileExits from Base Elements plug in and I discover to day that plugin don't run on iPhone and iPad.
Create a script to look for the external data source
Open File(DB Name)
Sohw Custom Dialog ["XXXX"]
this should send a custom dialog that indicates that you are not connected to your expected external datasource. If it connects it will not send any message
You could use PSoS if the server has the BaseElements plugin to run the BE_FileExists function assuming the current file is hosted in FileMaker Server.
Thanks CJ, That seems to work well and is easy to script for the first check when the file opens. To verify that the scripts connect to the correct table and field etc, I added a boolean field to my global table of one file that I use to transfer data back and forth. That field is marked as found from the other file just to be sure that it is connected properly in both directions.
Thanks Everyone for the responses. I am not on Server. I will keep in mind using SQL as well.