I have two dropdowns, one for category and the other for sub category. The category dropdown is loaded automatically and the sub category dropdown should be loaded based on what is chosen on the category dropdown. All data is coming from a database table, one is category and the other one is sub category. I am using oracle database. Thanks in advanced.
Have you got any code you need help with? I don't think anyone here is going to do all this for you.
You'll probably need to do an ajax call to populate that related select. This post on StackOverflow gives you the basics. No offense to Ben, but ignore his advice on using cfselect (you should avoid the cfform tags if at all possible).