Related combo boxes

[dealwi8me]

I have Table Products and Table Types. I've created another one ProductTypeRef where i save the references. For example:

Products
Id Description
1 Shoes
2 Clothes
3 Hats

Types
Id Description
1 Athletic
2 T-Shirts
3 Trousers

ProductTypeRef
IdProducts IdTypes
1 1
2 2
2 3

I have two combo boxes, Products and Types. How can i relate these two combo boxes?I mean if the user choose Shoes from product combo box, he'll get (as a choice) only the Athletic (or all the available values for the Shoes product) from the types combo boxes.

Any suggestions?

Thank you in advance.

 

[Smart]

Create a new query that has the products and types table
select the types and product (in the criteria section of the product enter this
forms![yourform]![yourcombobox1]

Base the second combobox on the above query

in the on enter of the second combo box type this
Me!yourcombobox2.Requery

 

[dealwi8me]

That works.

Thanks