# "2-way relation" possible?

**URL:** https://community.glideapps.com/t/2-way-relation-possible/19723
**Category:** Ask for Help
**Created:** [December 11, 2020, 4:56pm UTC](https://community.glideapps.com/t/2-way-relation-possible/19723 "2020-12-11T16:56:28Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)
#### Post date: [December 11, 2020, 4:56pm UTC](https://community.glideapps.com/t/2-way-relation-possible/19723/1 "2020-12-11T16:56:29Z")

</div>

I have a categories sheet and a products sheet, every product belongs to a certain category,  
what I would like the app to do is that when the user modifies the name of a certain category in the categories sheet, the category of all related products will change accordingly in the products sheet.

I feel there is an easy way to do it but I can’t grasp it. Thanks if you will help

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 11, 2020, 5:54pm UTC](https://community.glideapps.com/t/2-way-relation-possible/19723/2 "2020-12-11T17:54:16Z")

</div>

What are you looking to change specifically? Can you give us a specific scenario—there are a few solutions depending on what you’re looking to do.

---

<div class="post-metadata">

### Author: ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)
#### Post date: [December 11, 2020, 6:13pm UTC](https://community.glideapps.com/t/2-way-relation-possible/19723/3 "2020-12-11T18:13:36Z")

</div>

Thanks for answering;

I would like that when the user modifies the name of a certain category in the categories sheet, the category of all related products will change accordingly in the products sheet

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 11, 2020, 6:45pm UTC](https://community.glideapps.com/t/2-way-relation-possible/19723/4 "2020-12-11T18:45:53Z")

</div>

To do that, you’d probably really need two “categories” a unique category ID (the one that works behind the scenes as the true “category” and then a category display field that’s what’s seen by the user. Any other than this will break relations between the sheets when the category is renamed.

---

<div class="post-metadata">

### Author: ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)
#### Post date: [December 11, 2020, 11:06pm UTC](https://community.glideapps.com/t/2-way-relation-possible/19723/5 "2020-12-11T23:06:14Z")

</div>

I think I’d have the user that created the category to manually insert the category two times in that case, and in the products category display it would be a look up?

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 11, 2020, 11:53pm UTC](https://community.glideapps.com/t/2-way-relation-possible/19723/6 "2020-12-11T23:53:44Z")

</div>

correct.

---

<div class="post-metadata">

### Author: ![Nicholas\_Sollazzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicholas_sollazzo/32/57290_2.png) [@Nicholas\_Sollazzo](https://community.glideapps.com/u/Nicholas_Sollazzo)
#### Post date: [September 22, 2024, 5:06pm UTC](https://community.glideapps.com/t/2-way-relation-possible/19723/7 "2024-09-22T17:06:14Z")

</div>

Hey MaxB, I made a request to the Glide team to make a native many-to-many relationship if you could give it an up vote we might be able to actually see this feature come to life 🙏

> [@Native Many-to-Many Relations](https://community.glideapps.com/t/native-many-to-many-relations/76536):
>
> It’s 2024 (almost 2025) and we still don’t have a native way to create Many-to-Many (aka “two ways relations” or “multiple to multiple relation”). We have hacks, we have third-party tools but that’s an ESSENTIAL feature. When can we see many-to-many relations live natively in Glide?
