Resources /
Blog

A Comprehensive Guide to Field Dependencies in Salesforce

Submit your details to get a book

Min Read
Resources /
Blog

A Comprehensive Guide to Field Dependencies in Salesforce

Download

Submit your details to get a book

Min Read

A field dependency in Salesforce controls which values are available in one field, called the dependent field, based on the value selected in another field, called the controlling field. It is a filter, not an automation rule.

That distinction matters. Field dependencies are frequently confused with validation rules and flows, which do very different jobs. Field dependencies do exactly one thing: they narrow the options in a picklist so users only see choices that make sense for what they already selected.

This guide covers what field dependencies in Salesforce are, how controlling and dependent fields differ, which data types are allowed in each role, and how to create a field dependency step by step.

What Is a Field Dependency in Salesforce?

A field dependency in Salesforce is a filter that changes the values available in a dependent picklist based on the value selected in a controlling field. Salesforce reads the controlling field first, then shows only the dependent values you mapped to that selection.

The classic example is geography. If Country is the controlling field and State is the dependent field, selecting "United States" limits the State picklist to US states rather than showing every state and province worldwide.

Both fields must live on the same object and apply to the same record. A field dependency cannot reach across objects.

Field dependencies also do not enforce anything after the fact. They filter what a user can pick in the interface. They do not validate imported data, and they do not populate values automatically.

Controlling Field vs. Dependent Field: What's the Difference?

The controlling field determines which options are available. The dependent field is the one whose options get narrowed.

The two roles follow different data type rules. A controlling field can be a standard picklist, a custom picklist, or a checkbox. A dependent field must be a custom picklist or a custom multi-select picklist.

A controlling picklist needs at least one value, and Salesforce documents a ceiling of 300 values for controlling fields. If a field acts as both a controlling field and a dependent picklist in a chain, that same 300-value ceiling applies.

One controlling field can filter several dependent picklists. A dependent picklist, on the other hand, can have only one controlling field.

AttributeControlling fieldDependent field
RoleDetermines which options are availableHas its options narrowed by the controlling field
Allowed data typesStandard picklist, custom picklist, or checkboxCustom picklist or custom multi-select picklist
Standard fields allowed?YesNo, custom fields only
Multi-select allowed?NoYes
Checkbox allowed?YesNo
Value limitAt least one value, up to a documented ceiling of 300Standard picklist limits apply
How many can pair?One controlling field can filter several dependent picklistsEach dependent picklist has exactly one controlling field
Page layout ruleMust be present on the layoutMust sit below its controlling field on the layout

Can a Text Field Be a Dependent Field in Salesforce?

No. A text field cannot be a dependent field in Salesforce. Dependent fields must be custom picklists or custom multi-select picklists.

The same restriction rules out number fields, date fields, formula fields, lookup fields, and standard picklists. Standard picklists can serve as controlling fields, but Salesforce does not allow them in the dependent role.

If you need a text field to change based on another field value, a field dependency is the wrong tool. Use a formula field for a calculated value, or a flow when you need to write a value to the record.

Field typeCan be a controlling field?Can be a dependent field?
Custom picklistYesYes
Standard picklistYesNo
Custom multi-select picklistNoYes
CheckboxYesNo
TextNoNo
NumberNoNo
Date or Date/TimeNoNo
FormulaNoNo
Lookup or Master-DetailNoNo

How to Create a Field Dependency in Salesforce (Step-by-Step)

You need the "Customize Application" permission to define or edit dependent picklists. Confirm both fields already exist and have their values populated, because Salesforce will not build a dependency on an empty picklist.

  1. From Setup, click Object Manager and select the object that holds both fields.
  2. Click Fields & Relationships, then click the Field Dependencies button.
  3. Click New.
  4. Select the controlling field from the Controlling Field dropdown.
  5. Select the dependent field from the Dependent Field dropdown, then click Continue.
  6. In the field dependency matrix, the top row lists the controlling field values and the columns list the dependent field values. Select the dependent values that should be available for a given controlling value, then click Include Values.
  7. Repeat for each controlling value. Scroll horizontally if the matrix is wider than your screen.
  8. Click Preview to test the behavior. If your org uses record types, select a record type in the preview to see how it changes the available values.
  9. Click Save.

Exclusion works exactly as the name suggests. If a dependent value is not included for a controlling value, users do not see that option when the controlling value is selected.

Common Use Cases for Field Dependencies

Field dependencies earn their keep anywhere a long picklist has an obvious parent category. Three patterns cover most enterprise orgs.

Country to State or Province

Selecting a country narrows the state or province list to that country. Worth knowing before you build: Salesforce ships State and Country/Territory Picklists as a standard platform feature that already handles this for standard address fields. Build a custom dependency only when you need coverage the standard picklists do not provide.

Product Line to Product

A Product Line picklist controls a Product picklist so a rep who selects "Enterprise Platform" sees only the SKUs in that line. This keeps quoting accurate and keeps pipeline reports clean, because reps cannot pair a product with the wrong line.

Industry to Sub-Industry

An Industry picklist controls a Sub-Industry picklist, so selecting "Financial Services" surfaces options like Banking, Insurance, and Capital Markets. Segmentation stays consistent, which matters when marketing and sales report off the same field.

Field Dependency Limits and Gotchas

Most field dependency problems trace back to a handful of documented behaviors rather than a misconfigured matrix.

  • Both fields must be on the layout. A dependent picklist only shows filtered values when its controlling field is on the same page layout, and the dependent field should sit below the controlling field. The same rule applies to Lightning pages that use Dynamic Forms.
  • Field-level security is independent. Hiding a dependent picklist does not hide its controlling field. Hide both together or the filtering silently stops making sense.
  • Imports bypass the dependency. The Data Import Wizard does not honor field dependencies. Any value can land in a dependent picklist regardless of what the controlling field holds.
  • Replacing a controlling value breaks the dependency. If you replace a value in the controlling picklist, the dependency is lost and has to be rebuilt against the new value. Changing picklist value API names after setup breaks the mapping too, because dependencies are stored against API names.
  • Record types add a second filter. The record type determines which controlling values appear. The record type and the selected controlling value together determine which dependent values appear.
  • A required dependent picklist can still save empty. If no dependent values are available for the selected controlling value, users can save the record with that field blank.
  • Converting existing fields is safe for existing data. Turning existing fields into a controlling and dependent pair does not change values already stored on records. The rules apply to new records and to future edits.

Best Practices for Setting Up Field Dependencies

Keep picklist value counts manageable. A controlling picklist that approaches the 300-value ceiling produces a matrix that is close to unmaintainable by hand, and the admin who inherits it pays that cost every release.

Confirm the "Customize Application" permission before you start, and confirm the values in both picklists are final. Values added later are excluded by default, so every addition means a return trip to the matrix.

Build and test in a sandbox before deploying to production. Field dependencies are metadata, so they travel between orgs like any other configuration change, and a dependency that arrives half-mapped is easy to miss in a large release. Teams moving them with change sets should know the documented limits of that approach.

Document the mapping outside the matrix. Setup is the only place the logic lives, and Salesforce does not offer a report of controlling and dependent field pairs, so a simple spreadsheet saves the next admin hours.

Preview against every record type before you save. A mapping that looks complete under one record type can leave another record type with no available values at all.

Before you build
  • Confirm you have the "Customize Application" permission.
  • Confirm both fields exist on the same object.
  • Confirm the controlling field is a standard picklist, custom picklist, or checkbox.
  • Confirm the dependent field is a custom picklist or custom multi-select picklist.
  • Populate all values in both picklists first. New values added later are excluded by default.
  • Check that the controlling picklist stays well under the 300-value ceiling.
While you build
  • Map dependent values for every controlling value, including rarely used ones.
  • Click Include Values after each selection, not just at the end.
  • Use Preview to test the behavior before saving.
  • Preview against every record type in the org.
Before you deploy
  • Add the controlling field to every page layout that shows the dependent field.
  • Place the dependent field below its controlling field on the layout.
  • Check Dynamic Forms Lightning pages for the same pairing.
  • Align field-level security so both fields are visible or hidden together.
  • Test in a sandbox, then deploy to production.
  • Document the mapping outside Setup. Salesforce offers no report of dependency pairs.

Putting Field Dependencies to Work in Your Org

Field dependencies come down to one relationship: a controlling field narrows the values available in a dependent picklist. Get the data types right (standard picklist, custom picklist, or checkbox in the controlling role; custom picklist or custom multi-select picklist in the dependent role) and the rest is mapping.

The harder part is what happens after Setup. Dependencies built in a sandbox have to reach production intact, survive future releases, and stay documented as picklist values change. That is a release management problem rather than a configuration problem.

Flosum helps enterprise Salesforce teams deploy and govern declarative changes like field dependencies with full visibility into what moved, when, and who approved it. See how it works on the Flosum DevOps platform, or request a demo.

Frequently Asked Questions (FAQ)

What is a field dependency in Salesforce?
A field dependency is a filter that controls which values appear in one picklist based on the value selected in another field. The field that drives the filtering is the controlling field, and the field whose values get filtered is the dependent field. Field dependencies only filter picklist values. They do not trigger automation or update other records.
What's the difference between a controlling field and a dependent field?
The controlling field determines which options are available. The dependent field is the one whose options get narrowed. A controlling field can be a standard picklist, a custom picklist, or a checkbox. A dependent field must be a custom picklist or a custom multi-select picklist. One controlling field can filter several dependent picklists.
Can a text field be a dependent field in Salesforce?
No. A dependent field must be a custom picklist or a custom multi-select picklist. Text fields, number fields, formula fields, and standard picklists cannot be set as dependent fields. If you need a text field to change based on another field value, use a formula field or a flow instead.
Can a checkbox be a controlling field in Salesforce?
Yes. Checkbox fields can be controlling fields, but they cannot be dependent fields. When you use a checkbox as the controlling field, the dependency matrix gives you two columns, Checked and Unchecked, and you choose which dependent picklist values are available for each state.
How do you create a field dependency in Salesforce Lightning?
From Setup, open Object Manager and select your object. Click Fields & Relationships, then Field Dependencies, then New. Choose the controlling field and the dependent field, click Continue, then use the matrix to select values and click Include Values. Use Preview to test the behavior, then click Save.
Can a dependent picklist have more than one controlling field?
No. Each dependent picklist can have only one controlling field. You can chain dependencies so that one field controls a second field, which in turn controls a third, and a single controlling field can filter several dependent picklists. Record types also narrow available values alongside the controlling field.
What data types are allowed for controlling and dependent fields?
Controlling fields can be standard picklists, custom picklists, or checkboxes. Dependent fields must be custom picklists or custom multi-select picklists. Multi-select picklists can be dependent but never controlling. Checkboxes can be controlling but never dependent. Text, number, date, formula, and lookup fields cannot be used in either role.
Table Of Contents
Author
Stay Up-to-Date
Get flosum.com news in your inbox.

Thank you for subscribing