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.