Multiple Drivers for Dependent Dropdown
I am maintaining a list formatted line item dependent on its parent to provide the end-user a "picklist" using which they can select list items basis their selected parent.
However, I want to show only some items on the picklist instead of all based on a list property(say Active?).
The only solution I can think of is to create a new list of Parent&Active? and use that to drive the dependent picklist.
Is there a better way to do this?