I have made 2 drop down box naming client, project .
All values in this drop down box are coming from database. I am fetching all value through sql query. First drop down box is showing all client which are in database. Second drop down box is also showing all project which are in database.
For example, I have three client whose name are sam,due,joy. Each of have these have different project . Like sam have project like pro2, pro3 and due have DTL,Pro1 and joy have pro5,CMM,PPC like this.
Now problem is that when i select First client from drop down then it should only show that project in second drop down box which project come under first client .But this is showing all projects which exists in database.
I do not know what event i will have to use for this . As i think like onchange or onselect event and what type of code i will have to use for these events. If there is another way to solve this problem. So how i can do this . Please help me.