8

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???

5
  • If you can make third picklist dependent on second then i see possible chances of doing this Sep 18, 2013 at 6:33
  • I tried doing that... If u create test3 dependent on test2. Its doesnt serve my purpose as u can see.. if i make IST dependent on CA... everytime i select CA from test2 i will be able to see IST. Wherin i dont want to see IST for CA where test1 values are FIRst and SECOND
    – TestNS
    Sep 18, 2013 at 6:42
  • thats where i see as impossibility for this requirement .With visualforce we can achieve this . Sep 18, 2013 at 6:45
  • Ok will try with that... could you please help me out with sample code if any
    – TestNS
    Sep 18, 2013 at 6:46
  • 1- Dependent picklist cannot have more than one controlling field 2- Controlling field can have multiple dependent picklists
    – PPB
    Jul 10, 2018 at 9:19

3 Answers 3

4

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.

1
  • 1
    No problem @TestNS. I know it isn't ideal, but if this is the solution to your issue please mark this as the answer. It is important for the site to maintain a high answer rate. Sep 23, 2013 at 12:52
0

Did you ever get an positive answer to this question?

After a long search on the internet i decided to make every value unique in the different picklists by adding a combination of letters and numbers at the end of each value (it's a little bit more work connecting the values) for users to pick from. For reporting i created additional formula fields in which i delete the extra letters and numbers and so creating a field with the right value names on each level.

-2

test3 is dependent on test2 as well as test1 so the only way to do it is with a custom controller because standard field dependency has only one-level of dependency.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .