Default Record Picker Options

These options are applied by default to all columns referred to this table.

The Default Record Picker defines what record values are used as choices (abbreviated entries) to simplify record selection and make it intuitive for users. By default, the Name Column values are used as abbreviated entries.

To set the Default Record Picker options

Click the Setup link in the top right corner of the window.

Choose a table and click a corresponding tab at the top of the window.

From the menu in the main frame select Tables > Table Properties.

Record Picker.png

Default Record Picker Option Description
Filter The Filter section is intended to set the filter criteria for the records that will be displayed in the reference column.
Sorting The Sorting section is intended to set the sorting order for the records displayed in the reference column:
Columns The Columns section defines how records will be displayed in reference columns created in the other tables. Here you can choose columns that will be used for presenting the list of related records. Such list is displayed, when a user edits the reference column data.