Define Entity Relationships

With the transactional entities in place, configure the three relationship pairs required by the Purchasing app:

1. PurchaseRequest ↔ PurchaseRequestItem
2. Quotation ↔ QuotationItem
3. PurchaseRequest ↔ Quotation

The following diagram shows the relationship direction and cardinality between the Purchasing entities.

▶ Diagram: Cardinality ERD

Figure 1:

This ERD illustrates how the transactional entities relate to one another and how they reference the shared Currency and CostCenter static entities across both header–detail structures.

Configure the entity relationships

Configure the many-to-one relationship first, then add the corresponding one-to-many relationship and select the first relationship as its inverse.

1. PurchaseRequest ↔ PurchaseRequestItem Relationship

1. Open the PurchaseRequestItem Entity Editor.
2. Navigate to ENTITY RELATIONSHIPS and click +.
3. Add the following relationship:

Setting	Value
NAME	request
TARGET ENTITY	Purchasing.PurchaseRequest
RELATION TYPE	many-to-one: Many instances of this Entity have a relationship to a single instance of the target Entity (e.g. Address → Person)

4. Leave all other properties at their default values.

5. Save and close the editor.

6. Next, open the PurchaseRequest Entity Editor.

7. In ENTITY RELATIONSHIPS, click + and add:

Setting	Value
NAME	items
TARGET ENTITY	Purchasing.PurchaseRequestItem
RELATION TYPE	one-to-many: One instance of this Entity has a relationship to multiple instances of the target Entity (e.g., Person → Address)

8. Leave all other properties at their default values.

✅

Tip

If the INVERSE RELATIONSHIP dropdown is empty, press F5 to refresh the Entity Editor, then check the dropdown again.

9. Save and close the editor.

2. Quotation ↔ QuotationItem Relationship

1. Open the QuotationItem Entity Editor.
2. Add a new relationship:

Setting	Value
NAME	quotation
TARGET ENTITY	Purchasing.Quotation
RELATION TYPE	many-to-one: Many instances of this Entity have a relationship to a single instance of the target Entity (e.g. Address → Person)

3. Leave all other properties at their default values.

4. Save and close the editor.

5. Next, open the Quotation Entity Editor.

6. Add a new relationship:

Setting	Value
NAME	items
TARGET ENTITY	Purchasing.QuotationItem
RELATION TYPE	one-to-many: One instance of this Entity has a relationship to multiple instances of the target Entity (e.g., Person → Address)

7. Leave all other properties at their default values.

8. Save your changes before continuing.

3. Quotation ↔ PurchaseRequest Relationship

1. Keep the Quotation Entity Editor open.
2. In ENTITY RELATIONSHIPS, click + and add:

Setting	Value
NAME	purchaseRequest
TARGET ENTITY	Purchasing.PurchaseRequest
RELATION TYPE	many-to-one: Many instances of this Entity have a relationship to a single instance of the target Entity (e.g. Address → Person)

3. Leave all other properties at their default values.

4. Save and close the editor.

5. Next, open the PurchaseRequest Entity Editor.

6. In ENTITY RELATIONSHIPS, click + and add:

Setting	Value
NAME	quotations
TARGET ENTITY	Purchasing.Quotation
RELATION TYPE	one-to-many: One instance of this Entity has a relationship to multiple instances of the target Entity (e.g., Person → Address)

7. Leave all other properties at their default values.

8. Save and close the editor.

Related concepts

Entity Relationships

Understand relationship direction, cardinality, inverse relationships, and how related entities are accessed.

Transactional Entity Editor

Learn how to configure transactional entities in the Entity Editor.