I have two tables that I need to print things from in tandem. Fabrication Schedule is a table that gets updated daily and I print two different reports for each entry on a given date. I already have the macros and queries for printing the reports by date figured out. What I need to add to this is attachments from my Part Drawings table. It has all existing part numbers and their drawings as attachments.

I need to design a query that will look at the part numbers listed on the Fabrication Schedule by the date selected by my Date query and find the appropriate part drawings out of the other table. I want to be able to write one command button macro to pull up the attachments and print them the way I did for my reports.



Queries and lookup columns keep telling me that the attachments column is not valid. Any suggestions?