[SalesForce] Picklist dependent on 2 controlling picklist

I have 3 picklist in an object Test1, Test2, Test3
1. Test2 is dependent on Test1
2. Test3 is dependent on both.. Test1 and Test2

enter image description here

I want to have Test3 picklist showing values accordindly. i.e
if U selected Test1 = First and Test2 = SA . I should be able to see "IST,ABC and PQR" in Test 3.

Is this possible???

Best Answer

This is not possible with standard dependent picklists. Instead, you would have to use Visualforce. Specifically, look into using <apex:selectOption> and populating it with a List<SelectOption> from the controller. You can then utilize an <apex:actionSupport> with the event="onChange". You can then filter the results by rerendering the dependent picklists and filtering through Apex in the controller.

Related Topic