That may or may not be possible and there may be alternatives that will work.
Are these all PDF's saved from your Database?
If not, Are these PDF's single page or multiple page documents?
The actual invoice is created from the database directly.
The other items are scanned, named with our reference number and saved in the same folder as the Invoices. The scanned images are sometimes single sheet and often can be multiple sheets. As an example, we collect documents from different sources throughout the day, and each stop or collection is saved as one PDF with multiple pages. There can be many stops, many PDF's that will need tobe attached to the customer's invoice.
Thanks for such a quick response Sir.
Then printing out all of these from FileMaker alone cannot be done. If each scanned document was a single page, we could take a shot at using large container fields for displaying the file contents for printing purposes.
FileMaker could open all of the PDF's and then you can print each from the application that has opened the PDF's, but to automatically print them would require creating a system script that can print them and using FileMaker to print them. The exact details for that, if it is even possible, depends on whether you are doing this on a Mac or Windows platform.
And you might do a web search to see if any Plug ins offer any added capabilities for working with PDF files.
Is it possible for you to offer a script suggestion on how to at least get me in a position to search the separate folder and retrieve all the associated pdf files with the specific records reference number? I think if I can get the system to pull all the related scans, I can work around the printing issue. Also, will this procedure allow me to show the found set of pdf's in a thumbnail directly in the original record? Thank you again, and looking foward to your scripting suggestion.
Each such PDF should be inserted (can be inserted "by reference") into a container field in a related table, one record for each such document and linked by InvoiceID to your invoice table. IT will not matter to the database whether these files are in separate folders for each invoice or all in one folder.
Then opening the files in "preview" or a PDF reader is simply a matter of using a script to pull up the set of related records for that invoice and looping through them to use Export Field Contents or Go to Field (Files must be inserted with insert file, store a reference for go to field to open the file.) to open the files in your computer's designated application for opening PDF files.