A relationship represents the association between two entities. The direction of the arrows represents the relationship cardinality between the source and the target entities. In this article, you can find the steps to add a relationship and its various important properties. For more information, refer to the following sections.
This section describes the steps to add a relationship between the Orders and Customers entities such that many Orders records correspond to zero or one Customers record.
To add a new relation, click the Add Entity button on top of the model editor.
In the Add Relationship dialog box that appears, enter the name for the new relation.
Set the relationship cardinality to a required field from the drop-down such as 'N to 0..1'. Apart from this, you can specify whether to enable a bidirectional cross filter and make the relationship inactive through the Bidirectional Cross Filter and Make Relation Inactive properties.
Under the Relations section, specify a source entity from the list and choose its desired attribute.
Similarly, specify the target entity from the list, and choose its desired attribute.
Click the Add button.
The following table describes the important properties of a relationship that you can set in the Data Model Designer.