I am trying to set up a database that will store programs for me. I have an ID, part number, revision, and material for each attachment. I have been trying to come up with a way for a query to pull all related attachments based on the previous criteria.
I have been trying to use attachments because each individual program is only 1-2 KB in size. Every line has a single attachment due to the differing number of layers that all of my programs can hold. The goal of this database is to allow our operators to better use their nesting software across multiple orders.
At this point I have searched google, forums, and had no luck. I'm completely new to access so at this point I'm not even sure if this is something within its capabilities. Any help would be greatly appreciated!