Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
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
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???
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.
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.
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.
