# Step 4 of 8: Preparing the Data Schema

## Content

In this step you will create a **Categories\_Product** and a **Suppliers\_Product** relation for the **DataSet1**.

1. Take the **CategoryID** field with the mouse in the Categories table and drag&drop it to the **CategoryID** field in the Products table. You'll see the following window that creates a new relation between two tables:

 ![](https://cdn.mescius.io/document-site-files/images/9533f9b7-015c-42ba-9666-c32678ceddaf/documentsgraphics/relationdialogbox.png)

2. Take the **SupplierID** field with the mouse in the Suppliers table and drag&drop it to the **SupplierID** field in the Products table.

 You'll see the following window that creates a new relation between two tables:
 
 ![](https://cdn.mescius.io/document-site-files/images/9533f9b7-015c-42ba-9666-c32678ceddaf/documentsgraphics/relationsuppliers.png)