# How to add a multi-row relationship in the "parent" row

**URL:** <https://community.glideapps.com/t/how-to-add-a-multi-row-relationship-in-the-parent-row/43556>\
**Category:** Ask for Help\
**Created:** [June 27, 2022, 1:03am UTC](https://community.glideapps.com/t/how-to-add-a-multi-row-relationship-in-the-parent-row/43556 "2022-06-27T01:03:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)\
**Post date:** [June 27, 2022, 1:03am UTC](https://community.glideapps.com/t/how-to-add-a-multi-row-relationship-in-the-parent-row/43556/1 "2022-06-27T01:03:02Z")

</div>

I have this tables:  
-Orders  
-Products

Every order has to contain multiple products so what I want is:

1- When the user add a new order (through the Show Form Screen action) he will fulfill the differents order fields.  
2- after fulfill the orders fields, the user should add products to that new order. The user should be able to add endless products to that order

Is there a way to do that in just one screen? in the data editor which relation should I do?  
Thanks!

---

<div class="post-metadata">

**Author:** ![glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glide/32/53398_2.png) [@glide](https://community.glideapps.com/u/glide)\
**Post date:** [January 28, 2023, 12:34am UTC](https://community.glideapps.com/t/how-to-add-a-multi-row-relationship-in-the-parent-row/43556/2 "2023-01-28T00:34:50Z")

</div>

Yes, you can do this in one screen using a Multiple Relation column. In the Data Editor, add a new column of type Relation and select the Match Multiple option. Then, specify the values to be matched between the Orders and Products tables. This will create a relation between the two tables and allow you to add multiple products to each order.

This link could be useful: [Glide Docs • Relations](https://www.glideapps.com/docs/reference/computed-columns/relations)

_This is an experimental automatic reply from a bot. Please like it if the answer is correct._
