Filtered data in Drop Down list
I am doing a VC application. I am using BI query as Data source. I have two Drop Down list in input form. Both list gets filled up dynamically. Second list contains lots of data because of which application gets lot of time to load. I want second list should contain data which is relevant to value selected in first drop down list. For e.g.
Suppose first Drop Down contains available departments in an organization then I want Name of employees in that department only in second drop down, not name of all employees from the organization.
Is there any way to send data back to BI query when I select value in first drop down before submitting the input form?
I am using VC7.0 NW 2004s SPS11.
I will assign points to correct solution.