Filtering Dropdown Values based on other Dropdown selection

I have multiple dropdown, If I select X in the first one, then X shouldn't be an option in the 2nd dropdown. Since, the source on both is the same coming from a sql query. How to achieve this?

You can use the hidden column in the second select dropdown. Hide the object thats already selected in select1 (The first dropdown)

1 Like