30. Predefine the relationship between Customers and their Orders

Note: The scenario below uses data from the DESelect Demo Data Package.

Scenario: You want to predefine the relationship between the Data Extensions DESelect_DEMO_Customers and DESelect_DEMO_Orders.

Note: This scenario uses the feature Predefined Relations. You can access this feature through the Admin Panel.

On the Admin Panel overview screen, click on the Relations option on the sidebar.

You should now be transferred to the overview of all the existing predefined relations.

Click on the New Relation button to create a new relation.

1. Select the first Data Extension of the relation.

• On the first dropdown, with the label Data Extension select DESelect_DEMO_Customers.
• On the second dropdown, with the label Field select Id.

2. Select the type of relation.

In order to decide which type of relation to choose, we need to understand how our data are related. Since we have customers and orders, and each customer can place many orders, the type of relation to choose is 1-to-many.

• On the third dropdown, with the label Has a select 1-many.

3. Select the second Data Extension of the relation.

• On the fourth dropdown, with the label Relation With select DESelect_DEMO_Orders.
• On the fifth dropdown, with the label Field select CustomerId.

Click on the Save button to create the predefined relation.