Salesforce Advanced Administrator Certification Guide

Dependent picklists

Let's spend some time discussing dependent picklists. They are single or multiselect picklists whose values depend on a controlling field that must be a picklist field (with at least one value and fewer than 300 values) or a checkbox field for the same record.

This relation between fields helps keep data accurate and consistent.

Let's say we want a secondary picklist on a Case Detail object called Invoice Reason whose values depend on the Invoice Type. We want this to have the following relations:

Controlling value (invoice type)	Available values (invoice reason)
Purchase	Store purchase Online purchase
Subscription	Monthly subscription Weekly subscription
Reimbursement	Wrong purchase Flawed item

Dependent picklist ...