Still looking for a hand with this. Appreciate any ideas or leads.
Yes, you're right that the "absolute" and "relative" paths are the cause of your problem. "Relative" means "relative to the open local FileMaker file." In a networked situation there is no local file. Also, the FileMaker functions, like Get (TemporaryPath), return paths meant to be used in absolute paths; they begin with a / (root). They are not however complete, because they don't have the OS system prefix (why, I don't know, maybe so they can be used otherwise?).
So you should use an absolute path; which requires a prefix for which platform you're on. That is NOT provided by Get (TemporaryPath), so you need to add it. There is a function to do so, but you need to know how to use it. Example, using Let() to set up the correct prefix and filepath for a variable:
prefix = Case ( Abs ( Get (SystemPlatform)) = 1; "filemac:"; "filewin:" );
prefix & Get (TemporaryPath) & "Proceeds.xls"
(hope that's right, FileMaker is busy right now, so above is pseudo code)
Thanks, Fenton. I'll reread your post in the morning when I have more brain cells firing. Appreciate your sharing your insights.
Got in late tonight so I'll take advantage of your response tomorrow and test it out. Thanks again.