Dynamic Dropdown Box

Hello, I’m very new to coldfusion and I’m trying to modify the existing form. Here is my requirement…

I have two dropdown boxes, based on the first drop down box, I like to fill the box two. 

Table Emp,

EmployeeNbr, EmployeeName

1,John

2,David

3,Vic

Table Dep,

EmployeeNbr, DepNbr,DepName

1, 1, Wine

1,2,HP

1,3,IBM

2,1,Phone

2,2,Mouse

3,1,Cable

…

I will be using the cfquery to populate the dropdown box1, If user select the employee nbr2 in drop down box1 I like to display depends records in dropdown box 2. Please guide to code this.

Thanks