I have 2 tables in MS Access database : T_department and T_csc_details, the fileds of which are as follow :
T_Department : dept_cd , dept_service,dept_desc
T_csc_details : dept_cd , csc_cd,csc_details

I want to have a dropdown box in an asp page in which all dept_service from t_department table should be populated.After selecting a particular dept_service, corresponding description(dept_desc) should be displayed in a text box and another dropdown box should appear in which csc_details of that particular department should populate.
N.B: these 2 tables are linked with dept_cd.

pls. suggest and if possible send the code..