1 Reply Latest reply on Jan 10, 2017 6:26 AM by florian1

    Reverse Pick List Validation Help

    phan10ms Apprentice

      Hi All,


      I'm wondering if any of you folks have found a way to have validated pick lists go both ways.  Currently I'm able to go top down.  For an example, I can select a TEAM and then have a list of team members associated with the TEAM in question.  However, I would also like to know how to make it so that I can select a member in a scenario where the TEAM is unknown and then get a list of TEAMs that member is associated with.

        • 1. Re: Reverse Pick List Validation Help
          florian1 Expert

          I don't think it is possible while using the same PickList.


          So you will have to create a new PickList in a reversed way:

          1) Picklist for Employees (or use any existing):

          2) PickList for Teams by Employee:

          [Employee#.Rev2]RecId Equal To {0}

          3) use the lists in your SR:



          Teams (take care of the cascading validation):


          Result after choosing my name:

          3 of 3 people found this helpful