Purpose of Constraint Picklists is to restrict or constraint the values of child Picklist based on the value of parent.
The only reason behind using Constraint PickList over Hierarchical Picklist is due to the limitation of Hierarchical Picklist showing all the values including child Picklist values.
Steps to configure Constraint PickList
Step 1: Create Two LOV Type
Create two LOV type “STATUS1” and “COUNTRY1”, as shown below
(Site Map -> Administration – Data -> List of Values Explorer/LOV Explorer)
Step 2: Create LOV Values
For “COUNTRY1” define List of values such as INDIA, AUSTRALIA, UK etc.
For “STATE1” define List of values such as London, MP, UP, Melbourne, New York and in the “Description” field give the corresponding COUNTRY value (INDIA, AUSTRALIA, UK etc.) as shown below.
Step 3: Create PickList
Create two PickList in Tools as shown below
Here the BC is to be “PickList Generic” for both the PickLists.
Step 4: Select the BC where we have to add the PickList
Select the required BC where we need to add the PickLists.
Give the PickList Names in the corresponding Fields of the BC in the “PickList” field as shown below.
(Immediate post changes field should also be checked)
Define the Pick Maps for the respective fields as shown
While defining the Pick Maps for the Child Field (In this case “INS Area”), in the “PickList Field” of Pick Maps give “Value” for Child Field and “Description” for Parent field.
While defining the Pick Maps for the Parent Field (In this case “INS Product”), in the “PickList Field” of Pick Maps give “Value” for Parent Field and “Dummy” for Child field.
NOTE- Dummy Filed is created to blank the child in Constraint PickList when parent is none. “Dummy” field is present in “PickList Generic” BC.
Step 5 Compile all the created and changed objects
Step 6 Result
The Result will be as shown below.
If the Country is selected as “Australia” then the field that contains the state values will display only those value in the PickList that are associated with the respective country. In this case “Melbourne” and “Sydney” are associated with “Australia”.
Recommended Article: Hierarchical PickList