Populating second drop menu using the selection in the first drop menu
Posted on 2006-04-15
My DB has two related tables, the Category and Subcategory tables. (tblCat and tblSubCat)
the fields in tblCat are: CatID , CatName
the fields in tblSubCat are: SubCatID , SubCatName , Category
As you can see tblSubCat.Category and tblCat.CatID are relating the two tables.
Now first drop menu is populated from tblCat using the CatName as options and passing CatID as values.
I want to get the second DropMenu to be populated with only the SubCatName values where tblSubCat.Category = tblCat.CatID