Add a Relationship

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 descriptions about the important properties. For more information, refer to the following sections.

Add a Relationship

This section describes the steps to add a relation between the Customers and Orders entities such that zero or one Customer record corresponds to many Orders records.

1. To add a new relation, click the Add Relationship button at the top of the model editor.

   
   

   
   

   
   

2. In the Add Relationship dialog box that appears, enter the name for the new relationship.

   
   

   
   

   
   

3. Set the relationship cardinality to '1 To 1', '1 To N', '0..1 To N', 'N To 1', and 'N To 0..1'.

   
   

   
   

   
   

   Use the Bidirectional Cross Filter and Make Relation Inactive toggle buttons to

   control the behavior of the relationship.

4. Under the Relations section, specify a source entity from the list, and choose its desired attribute.

   
   

   
   

   
   

5. Similarly, specify the target entity from the list, and choose its desired attribute.

   
   

   
   

   
   

   If the isUnique property of the source attribute on the 1-side of the relationship is not set to True, a dialog box will pop up where you can enable it.

   
   

   
   

   
   

6. Click the Add button. A newly added relation will appear in the list of relations of the data model's entity.

   
   

   
   

Search an Entity/Attribute

While adding a relationship, you can search for an Entity and its associated Attributes by using the search bar in the Source Entity/Attributes dropdown list, and the Target Entity/Attributes dropdown list as shown below.

Important Properties

The following table describes the important properties of a relationship that you can set in the Data Model Designer.