A user wants to create a dependent dropdown field on a Customer form. On the custom field record, which column on the Sourcing & Filtering tab establishes this type of dependency?

To create a dependent dropdown field, the "Sourcing & Filtering" tab on the custom field record is used. The dependency is established by filtering the list of available options based on the value of another field on the same form. The Compare to Field column is used to select the controlling field on the current record. The system then compares the value in this field against a field from the source list (specified in the "Filter Using" column) to dynamically filter the dropdown options.

A. Compare Value To: This option is used to filter a list based on a static, predefined value, not on the dynamic value of another field on the form.
B. Value Is: This is a comparison operator used within filter criteria (e.g., in saved searches or workflows), not the column that selects the controlling field.
D. Field Is: This is a comparison operator, similar to "Value Is," used for comparing a field to another field, but "Compare to Field" is the specific column name for this configuration.

1. NetSuite Help Center: Sourcing Information for a Custom Field.

Section: Sourcing & Filtering Tab

Content: The documentation details the columns on the Sourcing & Filtering tab. It explicitly states: "In the Compare to Field column, select the field on the current record to which you want to compare the Filter Using field." This directly confirms its role in creating dependencies.

2. NetSuite Help Center: Creating a Dependent Dropdown List.

Section: Step-by-step instructions.

Content: This guide walks through the process, illustrating that to make a custom field's list dependent on another, you must set a filter where the "Compare to Field" column points to the independent (controlling) field on the form.

3. SuiteAnswers: Creating Dependent Dropdown Lists (Answer ID: 9921)

Section: Procedure

Content: This official support article provides a practical example. In step 11, it instructs the user to "In the Compare to Field column, select the field on the record that will be the parent dropdown." This confirms its function as the link for the dependency.