[]
        
(Showing Draft Content)

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 on top of the model editor.

    Add Relation in Model Editor

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

    Add Relationship Dialog in Model Editor

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


    Specify relationship cardinalities


    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.


    Specify relationship properties

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


    Specify relationship properties

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


    New Relationship between Entities

Important Properties

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

Property Name

Description

Name

The name of the relation.

Cardinality

Defines the rules and restrictions for the relation's behavior in the entity tree and query building. Possible values are '1 To 1', '1 To N', '0..1 To N', 'N To 1', and 'N To 0..1'.

This property determines whether the Recursive property has an effect on the relation.

Bidirectional Cross Filter

Lets you apply a filter on both sides of the relationship. You cannot enable a bidirectional cross filter in the case of a one to one relationship.

Make Relation Inactive

Enables you to create a relationship active/inactive based on your requirements.

Condition

Indicates whether to base this relation on an existing logical relation from the list.