I have a container field which stores file references to a shared network folder.  It is populated by PC and Mac users.  I can script an "Open URL" so the PC users can open the files created by the Mac users, but have not been able to find a way for the Mac users to open references created by PC users.  Any advice?

The obvious one I guess: why store references?  Do people need to be able to get to the files outside of FM?

 

If not - and  you only want to keep the FM file size down - then use the remote container storage feature of FMS?

Yes, they need to get to these documents outside of FileMaker.  The documents are very large (hundreds of pages) and change often.

It's working.  I have a calculation creating the path based on the current OS, the OS that originally created the file reference, and contents of the GetValue (GetAsText (Doc_Container); 2 ).  This calculation is then set as a variable for the open document Send Event.  Now a Mac user can open a file referenced in the container field which was created by a PC user and vice versa.