Creating a parts list by filtering from multiple sheets

I have a parts database that has part numbers that correspond with the Equipment ID. I also have a work order sheet of current work orders that also has the corresponding equipment ID. Is a report the best way to generate a "parts list" for the current work orders? I have attached screen shots for both. Essentially I would want the report to look at the work order equipment ID and filter the parts database to show me the parts for Equipment ID 7183, 106, 372, and 648 (in this example). As those work orders change I would like the report to update to the parts needed. The idea behind this is that this would work as a purchase order as well when ordering parts. Any help is greatly appreciated. Please let me know if something doesn't make sense I am happy to elaborate just trying to keep it simple.