Override default record picker
You can override the default record picker and set specific options for the master records selection in a relation or in a reference column.
To override the default record picker in a relation, edit this relation and check the Override default record picker checkbox.
The Record Picker options are described below:
| Record Picker Option | Description |
|---|---|
Filter | The Filter section is intended to set the filter criteria for the master table records. |
Sorting | The Sorting section is intended to set the sorting order for the master table records: |
Columns | The Columns section allows you to select which columns will be used for presenting master table records. These column values will be displayed as record abbreviated entries, when a user edits the reference column data. |
A reference column always participates in relation, therefore if you adjusted the
Override default record pickeroptions in such relation, the same settings will be displayed in the corresponding reference column and vice versa.
You can override the default record picker and set specific options for the master records selection directly in a reference column. Just activate the Override default record picker option in the reference column settings. For instance:
In our example the record picker works this way:
