Pull down list based on the selection in another pull down list
Posted on 2004-08-05
I have a database of different types of articles that I need to organize by different categories such as "Printing", "Troubleshooting", and "Policies". In order to keep track of articles better there will also be sub categories for each different type. For example, Troubleshooting will include subcategories of the diffent types of problems that need troubleshooted, while Policies will have a completely different list of subcats.
When writing articles the user will have the option of picking what category and subcategory there article belongs to.
Is there a way to make the pull down list of subcats change depending on what category is selected form another pull down list? I am using Coldfusion 4.5.
this is a sample of the database i am using (as you can see subOf is a foriegn key for CATEGORIES and is used to show what subcat belongs to what cat):
id subcat subOf
1 HP 8150 1
2 HP 4050 1
3 Unix 2
4 Windows 2
5 Payroll 3
6 HR 3