This scenario is widely used in forms design.
1.Create two data connections (one for All Departments and the other for All Employees under a given Department)
- Invoking first data connection is pretty simple as it does not require any input.
- Second data connection requires an Input (DeptId) and return the Employee list for the given DeptId.
2.You will need to bind the First Drop-Down list as input to the second Data Connection.
3.On exit of the First Drop-Down, invoke the second Data Connection.
hence, each time the user changes the Department, the Web Service will get invoked with the selection DeptId.
Nith