Reference fields A reference field stores a reference to a field on another table. For example, the Caller field on the Incident table is a reference to the User [sys_user] table. When you define a reference field, the system creates a relationship between the two tables. Adding a reference field to a form makes the other fields in the referenced table available to the form. Note: A reference field can refer only to records from one other table. To add a field that can refer to records on any table, use the Document ID element type. Administrators can create new reference fields and configure several options for reference fields. Table 1. Reference field options Option Description Display values Each reference field stores a sys_id for each referenced record in the database, but the sys_id is not shown. The reference field shows the specified display value. Decorations A reference decoration is an icon that appears next to a reference field. Reference styles Reference styles are specialized field styles that control the appearance of reference fields. Reference qualifiers Reference qualifiers restrict the records that are available for reference fields. Cascade delete rules Cascade delete rules specify what should happen to records that reference a record that is deleted. Auto-complete By default, a reference field auto-completes as the user types in the field. Administrators can configure auto-complete settings. Reference key A reference key saves a field other than sys_id as the unique identifier for a reference field. Enable dynamic creation When dynamic creation is enabled, entering a nonexistent value in a reference field creates a new record on the referenced table instead of returning an error. Add a reference fieldAdd reference fields to a table using the same method as for any other field. Display valuesReference fields store a sys_id for each referenced record in the database, but the sys_id is not shown.DecorationsReference decorations are icons which appear next to the reference field.Reference stylesReference styles are specialized field styles that control the appearance of reference fields.Reference qualifiersUse reference qualifiers to create filters that restrict the data that is returned for a reference field.Configure cascade delete rulesWhen a record is deleted, there are different options for how the deletion will affect records that reference the deleted record. You can configure what happens to records that reference a record when that record is deleted.Auto-complete for reference fieldsBy default, a reference field auto-completes as the user types in the field.Define the reference keyBy default, reference fields store the sys_id of the record in the database.Enable dynamic creation for reference fieldsWhen dynamic creation is enabled, entering a nonexistent value in a reference field creates a new record on the referenced table instead of returning an error.Recent selectionsReference fields store a list of each user's recent selections to allow users to quickly select past values when filling in a reference field.