Multiple Dropdowns Qs

[maxyboy]

I have a form with a number of textboxes and then 3 dropdowns: Office, Department and Sub-Department. The data for these dropdowns is held in 3 database tables. When the user first enters the form, Office is populated, but not the other 2. On selecting an Office I need the department dropdown to be filled with departments for the chosen office. The same needs to happen to the Sub-department dropdown when a department is chosen. Phew.

What is the best way to do this? Should I try and get all the data in one go and use client side script to do the filtering or should I submit the form each time meaning more trips to the server (and database)

matt

 

[cfk]

If the user will be going through the process one or two
times a session it is best to use server side code.
If the user is using the process alot in any particular session use client side code.