dependent field

A dependent field is an entity field that creates a parent-child relationship between 2 entities. If you set the dependent field from one entity (the child) as the primary field of another entity (the parent), the data in the dependent field shows the data from the associated primary field.

A dependent field is similar to a foreign key in a relational database.

Example:

There are 2 entities: Customers and Orders:

  • In the Customers entity, CustomerID is the primary field.
  • In the Orders entity, CustomerID is a dependent field that is configured with a relationship to CustomerID in the Customers entity.
  • In the Orders entity, the CustomerID field shows the associated value from the CustomerID from the Customers entity.

Customers entity.

CustomerIDFullName
1Ola Hansen
2Tove Svendson
3Kari Pettersen

Orders entity.

OrderNumberCustomerID
778953
446783
224562
245621

Related Topics

About This Page

This page is a navigational feature that can help you find the most important information about this topic from one location. It centralizes access to information about the concept that may be found in different parts of the documentation, provides any videos that may be available for this topic, and facilitates search using synonyms or related terms. Use the links on this page to find the information that is the most relevant to your needs.

Keywords

foreign key, key, field, dependent field, relationship