We have an Access form that we use to enter data. There are hundreds of records with their own seperate linked pdf (field notes). In each record there is a box that we "insert object" into (our scanned field notes-a pdf file)- a linked document in each record that is associated with that record.
At the end of each year we print out reports from each record. We then print out the pdf documents (field notes) seperately and then match them up and file them together.
This seems crazy and barbaric to me because the pdf is already associated to the records!
Is there a way to print out the reports so that each associated pdf prints out with each report? (so that at the printer I see report1, pdf1, report2, pdf2, etc...?
This way I can just grab the papers from the printer and staple each report with its associated pdf... <I mean this is 2011 right? It seems like there should be a way to do it. They are already associated!>