When a reference field is added to a table, what value does it store in the database?

When a reference field is added to a table, what value does it store in the database?

• A. Sys_id of the reference record
• B. Display value
• C. Number
• D. Table name

Answer: (A)

Reference fields store the Sys_id of the record in the referenced table. This Sys_id is a unique identifier that links to the exact record, so the field acts like a foreign key. The value you see in the UI as a display string is derived by looking up that Sys_id in the referenced table and showing its display value, not the actual stored value. The field does not store the table name or a numeric value directly.

Reference fields store the Sys_id of the record in the referenced table. This Sys_id is a unique identifier that links to the exact record, so the field acts like a foreign key. The value you see in the UI as a display string is derived by looking up that Sys_id in the referenced table and showing its display value, not the actual stored value. The field does not store the table name or a numeric value directly.