I have a carrier table and a product table. The Carrier table i have CarrierID and Carrier Name. In the Product Table I have ProdID,Carrier, and Product name. What I want to accomplish on a form is when I select a carrier in a combo window and then select Product in another window , I want to only display the products for that specific carrier. I don't know exactly how to achieve this - although I think its pretty simple. Please help

Software/Hardware used:
MsAccess 2003