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

Sounds like cascading combos:

http://www.baldyweb.com/CascadingCombo.htm