Container fields can store any file type, be they PDF or Excel files. Container fields will even display single-page PDF documents directly in FileMaker Pro. Otherwise, you can double-click the file in the field to have the OS automatically open it with the default application.
Thanks David. I forgot to mention that I tried storing the PDF file in a new container field that I created. Maybe I missed a step...I don't know, however, when I did this the file name shows up but does not open or do anything at all when I double click on the file name in the container field. The steps I took were the following:
File--> Manage Database
Entered field name and selected "container" as the type.
Then in the Browse mode I right-clicked on the new container field and selected "insert file". Then I selected the PDF file from my desktop.
Have I missed a step?
Ah! I forgot to mention a caveat. The document will open automatically only if you include a reference to the file. If the file is actually stored in the container field, then you will need to export the file before it can be opened. The opening of an exported file can be automated with a script.
Umm, since I have never created or worked with Scripts I am following the help instructions as best i can. I am already stuck where it says to specify options. I chose the "Open file" command and the specify drop down menu shows <unknown>. I am guessing that this is my first problem because if I click there it brings up Add FileMaker Data source, Add ODBC data source, or Mange data sources. The Add Filemaker Data source brings up the window where I can choose the correct file, however, they are all shaded grey.
As you can tell, I am not an experienced user of FileMaker Pro...yet!
If you read the help information of the "Open File" script step, you will see it opens FileMaker Pro files. It will not open PDF or Excel files.
The script step you want is "Export Field Contents".