Page tree
Skip to end of metadata
Go to start of metadata

Linked Fields

Linked fields are special data types that automatically pull the values in the fields from one table, called the source table, into another table, called the target table. Linked fields help avoid duplication and ensure that records dynamically reflect any changes that occurred in other places within the infrastructure. Let's consider an example.

Example

Imagine you have a Vendor table that holds records for each of your vendors; a People table that holds the employees at your company, vendor contacts, and other outside contacts; and a Contract table holding information about your contracts.

Within a contract record, you typically pull in and display fields from the vendor record for the contract’s vendor, the names and email addresses of the main vendor contacts, and information about your own employees who are responsible for the contract. For example, the Party Main Contact section shows the information for a vendor contact pulled from the People table.

Within the vendor record, you might also show a Related Table of all contracts for that vendor, which links to the Contract table, as well as a Related Table of all vendor contacts, which links to the People table.

Although a linked field establishes a relationship with another table, it isn't just a window that shows the exact same information. You can rename the field to be more appropriate for the target table, such as changing the Full Name field from the Person table to display as Party Main Contact in the example above. You can also set whether the linked field updates automatically when the source data changes, or whether the initial value should remain static.

There are several types of linked fields, each appropriate to a different situation:

Beyond data types, these articles under Working with Linked Fields offer tips for using linked fields:

CONTENTS