We have a relational db for customers. I want to be able store price quotes and order files (typically pdf) in a container field so all salespeople and management can have access to quotes. The db structure is not the issue. The issue I am having is after creating the container field, then inserting a pdf into the field, it is awfully clunky trying to open the file.
When I insert as a file, the only way to access it is to export the contents (to desktop or whereever), then go there to open it. When I insert the file as an object, I can sort of open on a double-click on my Windows machine, it will open it in Acrobat Reader (even though my default is Nitro PDF). While that 'sorta works', when my sales manager on his Mac tries to open it, its interpreted on the Mac as an image, not a PDF.
Intuitively, you ought to be able to simply double-click on the file in the container field and have it open in the program it was created in, much like double-clicking on an attachment in an email. Am I missing something here?
I have read other posts on the forum concerning container fields and have seen references to scripts. Is that what I have do? Write a convoluted script to do something that should happen natively?