A 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.
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.