Difference between Hierarchical and Constraint Picklist?
Purpose of both the Picklists is similar, to restrict or constraint the values of child Picklist based on the value of parent but we need to do different configuration to implement them.
The only reason I can think of using Constraint over Hierarchical Picklists is due to a limitation of Hierarchical Picklist showing all the values including child Picklist values.
Basic difference between Hierarchical and Constraint Picklist is as following:
|Hierarchical Picklist||Constraint Picklist|
|Business Component||Picklist Hierarchical||Picklist Generic|
|LOV||Same LOV for Parent as well as Child Picklist Field. Parent LIC field is used to establish a parent and child relationship||Different LOV is used for Parent and Child Fields.|
|Values||All the values in Parent Picklist including Child Picklist Values||Parent and child fields have different Picklists associated there is No overlapping of values|