Final answer:
A Reference field type is used to display records from another table in a database. It creates a linkage between tables and is essential for normalized database systems to prevent data duplication.
Step-by-step explanation:
The field type that displays records from another table in a database system is called a Reference field. This field type creates a relationship between two tables, making it possible to pull in related data from a separate table. For example, in a customer database, a Customer ID in an orders table might reference the customer's detail record in a separate customers table. This allows systems to maintain normalized databases and prevent data duplication. The other field types mentioned, such as Choice, String, and Attachments, have different functions. A Choice field provides a list of predefined options, a String field stores text data, and an Attachments field allows files to be uploaded and stored within the record.