Data modelling - Record
Lookup field
A field that automatically shows information pulled from a related record
What's it for?
To display related information without entering it again.
For example…
An order record shows the customer’s company name in a lookup field by pulling it automatically from the linked customer record