Is it possible to create dynamic sqls as source for List of Values.

Hi,

I have a requirement wherein there are three drop-downs(independent of one another), and based on the selection of any of these dropdowns I would like to populate my fourth drop-down.

Ex: 1st Dropdown: Instrument Type

2nd Dropdown: Instrument Class

3rd Dropdown: Trading Type

4th Dropdown : Positions (with multi-select) could be populated by selecting any of the above three dropdowns. Initially it will show all positions in the list but when any of the above dropdowns are selected, it will refresh the list based on that particular selection.

The three dropdowns comes from different tables. Is it possible to create a LoV with the above scenario? If so, could you please brief me the process.

Thanks,

Sathish.