Material_Inventory is a database containing all items.
The user selects items from Material_Inventory and gives the items quantities e.g. Description: pole, Quantity: 10
Wood_List contains only some items of Material_Inventory. BOM might/might not have items in common with Wood_List.
I want the query to link the 3 tables and show only the items that are common between the 3 tables. Basically Wood_List filters BOM which filters Material_Inventory.
Or alternatively I want Wood_List to filter BOM and use Material_Inventory to display Total_Quantity of the item in Wood_List.