Is there a way to change a picklist's values when (for example) another
picklist has a selection made.
Let's say picklist A has the values 1, 2 and 3.
Let's say picklist B has the default values X, Y and Z.
When 1 is selected in picklist A I want picklist B to have the values -
Apple, Bird and Chair
if 2 is selected in picklist A want picklist B to have the values - Door,
Echo and Fox