In a one-to-many relationship, you can control how the relationship behavior cascades to records in the related entity when records in the primary entity have actions such as assign, share, and delete performed on them.
When creating and editing a relationship, you can configure the type of behavior, as shown in the following screenshot:
Figure 3.13 – Relationship options
The type of behavior can be set to one of the following:
- Parental: Using this option means that for operations performed on a record in the parent entity, the same operations are performed on the child records in the related entity. For example, if the parent record is deleted, all the child records are also deleted.
- Referential:Â Using this option means that any operations performed on a record in the parent entity do not affect the child records in the related entity. This can lead to orphaned related records with no parent. If you choose the Referential option, a separate...
