Category and sub category problem

[gate bouch]

sorry for my english

I have created a product database. Each product belong to
a category and a subcategory.

I am trying to create a method to select the subcategory
for the product in a form. The drop down menu content
must be related to the selected category.

Exemple :

available categories : house, car, boat
available subcategories : small house, big house, small
car, big car, small boat, big boat.

I have assigned a key to the the category and subcategory
tables so i can connect subcategories that belongs to a
specific category.

I can easily create ASP pages that would allow me to
dynamically select a subcategory from a drop down menu
that would contain only related options but I can't do it
directly in access from a drop down.

Any clues...
..

 

[Sandra Daigle]

This is really just a matter of synchronizing combo boxes - basically that's
a fancy way of saying that you make the rowsource of the second combo
dependant on the value of the first combo.Here's a KB article that describes
how to synchronize two combos - post back if you need more help or further
explanation.

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb;[LN];97624



ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb;[LN];97624