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.
CustomerID | FullName |
---|---|
1 | Ola Hansen |
2 | Tove Svendson |
3 | Kari Pettersen |
Orders entity.
OrderNumber | CustomerID |
---|---|
77895 | 3 |
44678 | 3 |
22456 | 2 |
24562 | 1 |
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