Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Application Customization > Record Type Application Customization Page > About Cascading Picklists and Picklist Value Groups

About Cascading Picklists and Picklist Value Groups

You can use picklist fields that contain values that are mapped to picklist value groups in cascading picklists. However, in a cascading picklist definition, you can specify only one set of relationships between the values in the parent picklist field and the values in the related picklist fields, regardless of whether you select a picklist value group in the Picklist Value Group list when you define the cascading picklist. If a field is a related field in a cascading picklist definition, and if it is also mapped to picklist value groups, then the values that are available for selection in the field when a record is created or updated are filtered first by the picklist value group on the record and then by the cascading picklist definition.

As an example, assume that you set up the following configuration for the Account record type:

• The Account Type field and the Priority field are linked in a cascading picklist definition, with the Account Type field as the parent picklist field.
• The Picklist Value Group field, the Account Type field, and the Priority field are all present on the Detail page layout.

When the Picklist Value Group field is populated on an account, the values that are available for selection in the picklist fields are as follows:

• In the Account Type field, the values that are mapped to the picklist value group are available for selection.
• In the Priority picklist field, all of the values that are mapped to the picklist value group are available until a value is selected in the Account Type field. After a value is selected in the Account Type field, the values in the Priority field are limited to those values that meet both of the following criteria:
  • The value is mapped to the picklist value group.
  • The value is linked to the value in the Account Type field in the cascading picklist definition.

Related Topics

See the following topics for related information:

• Defining Cascading Picklists
• About Picklist Value Groups
• Considerations When Setting Up Picklist Value Groups
• Process of Setting Up Picklist Value Groups
• Creating Picklist Value Groups
• Mapping Picklist Values to Picklist Value Groups