Question: How to pass selected value from one dropdown to another in GridView at form level

1

I have a GridView with two dropdown lists in each row.

  • The first dropdown is bound to a global list named abc.
  • The second dropdown is bound to another source called xyz.

Now, I want the selected value from the first dropdown to act as a filter or input (i.e., as a WHERE condition) for the second dropdown.

Is it possible to pass this selected value to the second dropdown at the form level, and if so, how can I achieve it?