hi
i want to populate a dropdown box based on a selection made in another dropdown. however it doesnt seem striaght forward.
dropdown 1 is a list of departments and comes from a sql server database connection. i display department name (but sql server db also has a department ID field)
dropdown 2 - rather than showing all staff members, id ...