query based on table value

[chewy]

I have 2 tables that stores inventory for a department. tblItemInfohas a field ItemDesc and a ReorderAmt field. The other table is tblCurrentInv which has itemDescID and AmtOnHand. I want to make a query that runs through the ItemDesc and pick out all Items that are below their reorder amt. How do I set up the query to use the info from two tables?

 

[chewy]

here is a shot of the tables

 

[chewy]

any ideas what I could search for to find an answer in the archives?