How to return a value based on multiple fields and tables

[whisp0214]

I am new to Access, so I am sure there is an easy solution I can't find. Here is my issue.

The two tables I am working with are tblPurchaseOrders and tblCommissionRates. tblPurchaseOrders contains all PO's for our company along with Vendor ID and Retailer ID for every PO listed.

We handle many Vendors and Retailers and there is a lot of crossover. I.E. Vendor A does business with Retailer A,B,C and so on. Each retailer/vendor combination has their own unique commission rate which is stored in tblCommissionRates.(all possible combinations are in this table)



What I am trying to do is create a query that will pull the commission rate from tblCommissionRates based on the Vendor ID and Retailer ID combination on tblPurchaseOrders. If I need to be more detailed, please let me know.

Thanks in advance.

Jack

[CJ_London]

what you have described sound a bit simplistic, but if it is a complete description then both your tblPurchaseOrders and tblCommissionRates will have a VendorID field and RetailerID field so just join the two tables on both equivalent fields