We are currently building a database for viewing PDFs. However, we are wanting to only use the reference to the PDF, not placing the PDF itself in the container field. We are using a central location for the PDFs on one our Mac server(server 10.4.9) When we do this, anyone on a Mac can view the PDFs as long as they are connected to that specific server. The Windows users cannot. They receive a message saying that the PDF cannot be located. How should I go about setting this up? I'm assuming it's because the PC's are missing the correct path to the PDF. I've searched every where for a answer but I'm coming up short. Any help would be greatly appreciated. Thank you in advance.

Does the path contain characters that aren't legal in Windows, like forward- or back-slashes?

The file path doesn't have any illegal characters. I was able to make a calculation field and set it as a container. This allows me to locate the correct file path on either a Mac or PC. However, now I'm having a issue with exporting. If I have 5,000 records, how do I set that calculation field using a variable? Thank you for your help so far.