prathapvs 0 Newbie Poster

hi,
i need to populate a select box with values from database. but this should be done based on the value selected in the other select box previously.

for example,
i am having two tables.
1 for selecting domain
2 for courses offered in that domain. this table will have course_id as foreign key.

selectbox1 contains options like:
hardware
software

if hardware is selected, i need to connect to database again and obtain contents from hardware table and display them in selectbox2 (got from the database) as
CCNA
Hardware & Networking

if software is selected, i need to connect to database and obtain contents from hardware table and display them in selectbox2 (got from the database) as
java
C
C++

could you tell me how to implements it by using action, actionform and jsp
i am working on java web application
help me regarding this.