Link to Selected Fields from Another Table
Multiple fields from a source table may be linked to the current table in one operation. This is the most commonly used linked field data type. For example, when a user submits a Case, you may want to automatically include the name, telephone number, and email address. The data would be pulled automatically based on the user's login and could also be manually imported by selecting a different user in the Name field.
Let's assume that a record in the Company table needs information about a contract. This information can be pulled from a single record in the Contracts table. When viewed in the Power User interface, the linked fields will be displayed individually on the layout:
You can also have these linked fields hold multiple values, which changes their display to an embedded table. For more information on displaying linked fields this way, see Linked Fields Display.