CAD · Question #148
What field type would you select if you want to query records from another table on a form?
The correct answer is A. Use the Reference field type. The 'Reference' field type creates a relationship between two tables, allowing users to search and select a record from another table directly on a form. It stores the sys_id of the referenced record and displays a human-readable value (typically the display value of the target…
Question
What field type would you select if you want to query records from another table on a form?
Options
- AUse the Reference field type.
- BUse the Phone Number field type.
- CUse the String field type.
- DUse the Date field type.
How the community answered
(42 responses)- A93% (39)
- C5% (2)
- D2% (1)
Explanation
The 'Reference' field type creates a relationship between two tables, allowing users to search and select a record from another table directly on a form. It stores the sys_id of the referenced record and displays a human-readable value (typically the display value of the target record). This enables dot-walking to access fields on the related record. Phone Number, String, and Date field types are simple data-storage fields with no cross-table lookup capability.
Topics
Community Discussion
No community discussion yet for this question.