Unanswered: Populating a combo box based on a selection from another
I have a slight problem which is causing me a BIG headache, so I wondered if any one could help me out..
On a form I have 2 combo boxes, 1 is Categories and the other is Sub Categories both get their data from seperate tables (Categories & SubCategories).
I need to be able to populate the Sub Category combo box with the correct data depending on the choice the user made in the Categories section..
The 2 tables are set up llike this... Categories has a unique CategoryID field and a Category (name) field. The SubCategories table has a unique SubCategoryID field, a SubCategory (name) field and a Category field which contains the unique CategoryID number from the Categories table to show which category the sub category belongs to.
So if a user selected the Category - Relationships (CategoryID of 1) in the combo box I need the SubCategories combo box to only show all SubCategories that fall under CategoryID 1