I have a client that has a server full of image files (jpgs, pdfs, tiffs, etc). They have a FM14 database being served on FMS 14 (Windows Server 2012). They are accessing the server from FMP 14 clients on Macs and Windows all from within the same network.
They want to link records in a database to the image files. The want to start from a record in their client FMP, open up a dialog that allows them to search the server machine and choose a file that will be linked to that record. Later they want to go to that record and view the file.
Storing the files as containers won't work as the files will be edited (but their filepaths and names won't change). And the filepaths and file names have a strict naming convention that can't be changed.
How would you accomplish this?