{"section":"tutorials","requestedLocale":"en","requestedSlug":"creating-relationships-between-master-data-entities-using-admin","locale":"en","slug":"creating-relationships-between-master-data-entities-using-admin","path":"docs/en/tutorials/master-data/master-data-v1-applications/creating-relationships-between-master-data-entities-using-admin.md","branch":"main","content":"A relationship between entities is a reference between documents that belong to different domains. This reference is defined by a field in each entity. This field should be completed with the ID of the related entity's document and will not be visible to the user.\n\nFor example, assume your store has a **Customer** entity and a **Wishlist** entity. If you want each customer to be able to create multiple wishlists, you must create a field in the **Wishlist** entity to link each one of them to a customer. \n\n> ℹ️ Master Data has a few predefined relationships by default, such as Customer (CL) and Address (AD).\n\n## Creating a relationship between data entities\n\nTo create a relationship, there must be two data entities. If there is only one entity, you may create another following the instructions below. To learn more about data entities, see [Data entities](/en/docs/tutorials/data-entity).\n\nIn the example above, you need to create a data entity called **Wishlist** which will have a relationship with the **Customer** entity. This relationship will allow a customer to have multiple wishlists, but a wish list can only belong to one customer.\n\nCheck out the instructions below for the aforementioned example.\n\n1. In the VTEX Admin, access **Store Settings** > **Storefront** > **Master Data**.\n2. Click `Advanced settings`. \n3. Click **Data structure**. You will be redirected to a new page.\n4. Click the **Data Entities** tab.\n5. If you want to create a relationship in a new entity, click the `Add` button to create a new data entity.\n\n If you want to create a relationship in an existing entity, find it and click the edit button , then go to step 7. \n\n6. Configure the entity that will be created by completing the **Acronym** and **Name** fields and adding the desired fields. Learn more about fields in [Creating a field in Master Data](/en/docs/tutorials/how-can-i-create-a-field-in-master-data).\n\n In this example, the entity will use the name `Wishlist`, the acronym `WL`, and the field `wishlist` of type `Varchar 750`.\n\n For more details on how to complete these fields, see [Data entity](/en/docs/tutorials/data-entity). \n\n7. Add a field of type **Relationship** and define its name. In this example, it will be called `Customer`.\n8. Click the gear icon next to the **Relationship** field to configure it.\n9. Under **Custom field type settings**, select the entity you want to link and the field that will be displayed in the relationship. In this example, the relationship will be with the **Customer** entity, and the **email** field will be displayed.\n\n \n\n10. Click the `Save` button to save the settings.\n11. Click the publish icon to publish the entity.\n12. You may also need to update the applications to implement the changes. To do this, go to **Store Settings** > **Storefront** > **Master Data** and click the `Reload Applications` button.\n\n## Creating a relationship between documents\n\nYou can also create a relationship between documents once there is a [relationship between data entities](#creating-a-relationship-between-data-entities). To do this, you will need to edit the [form](/en/docs/tutorials/creating-form-in-master-data) of a data entity.\n\nFollow the steps below:\n\n1. In the VTEX Admin, access **Store Settings** > **Storefront** > **Master Data**.\n2. Click the gear icon next to the application name.\n\n You will be redirected to the list of forms in that application.\n\n3. To create a new form, click `+ New`.\n4. Enter the **Name** of the form.\n5. Select the **Data entity** to which the form will be linked. In this tutorial, we will use the Wishlist entity as an example.\n\n The entity's fields will be displayed in a list on the **List Fields** tab and can be selected to compose the form.\n\n6. Select the relationship field and any others you want to include in the form. In this example, we will include the **Customer** field (relationship) and the **Document ID** and **Wishlist** fields.\n7. Click the **Layout Schemas** tab to configure the form layout.\n8. Click `Add New Section` to create a section on the form.\n9. Name the section.\n10. Drag the relationship field (in this case, **Customer**) into the section and the other fields you want to include in the form.\n11. Click `Save`. You will be directed to the list of forms in the application, which includes the new form.\n12. In the new form's row, click the edit icon .\n13. Click the **Layout Schemas** tab.\n14. Next to the relationship field (in the example, **Customer**) click the edit icon .\n15. Select the **Combo box** option and click `OK`. This option allows you to select existing field values stored in the related entity when completing the form.\n16. Click `Save`.\n17. Click the **Applications** tab.\n18. Click the `Reload Applications` button.\n\nNow, when you create a new document from the form, you can select the desired value (in this example, the pre-existing Customer who will be linked to the Wishlist).\n\nYou can also view the related records by accessing each record of an entity. For example, you can view the `Wishlist` created by a `Customer` when accessing the customer's record.\n\nTo do this, you need to add the value `{relationship_entity_acronym}.{relationship_field_name}` to the entity's form in the **View queries** field. Example: `WL.customer`.\n\n## Adding filters to relationship fields\n\nRelationships are kept through document IDs. Trying to insert the relationship's field value as a filter in the form will return only the IDs of the referred documents, and not each document's value for the chosen field. The image below shows this result. For more information, see [How to filter data in Master Data](/en/docs/tutorials/filtering-data-on-master-data).\n\n"}