# Unable to get relations to work

**URL:** <https://community.glideapps.com/t/unable-to-get-relations-to-work/44212>\
**Category:** Ask for Help\
**Created:** [July 10, 2022, 2:03am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212 "2022-07-10T02:03:52Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![PJnotDJ](https://avatars.discourse-cdn.com/v4/letter/p/9fc29f/32.png) [@PJnotDJ](https://community.glideapps.com/u/PJnotDJ)\
**Post date:** [July 10, 2022, 2:03am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/1 "2022-07-10T02:03:52Z")

</div>

Hi, I’m trying to setup a relation that connects selected “choices” from a form in one tab to another.

I am building a restaurant notes application and in the form in the tab you can select multiple category tags like “BBQ, Tacos, Pizza, etc”. I have another tab that is linked to that “choices” in the first form that houses all these tags. Im looking to create a relation in the tags tab that links to the selected tags within the first form. This way a user can navigate to the tags tab select something like Tacos and see all the restaurants with that tag associated with it. I tried multiple ways to create multiple relations, but as a very new user to Glide I’m struggling to get it to function. I followed the relations guide, but to no avail. Any help would be greatly appreciated.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 10, 2022, 2:14am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/2 "2022-07-10T02:14:31Z")

</div>

Can you show how your relation is configured, the value you are using for the relation, and some of the rows you are attempting to relate to?

---

<div class="post-metadata">

**Author:** ![PJnotDJ](https://avatars.discourse-cdn.com/v4/letter/p/9fc29f/32.png) [@PJnotDJ](https://community.glideapps.com/u/PJnotDJ)\
**Post date:** [July 10, 2022, 2:19am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/3 "2022-07-10T02:19:13Z")

</div>

![Screen Shot 2022-07-09 at 10.16.12 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2f2b92b499da297cf53d515332af97ccee874737.jpeg)  
 ![Screen Shot 2022-07-09 at 10.16.27 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b486094d683dc9fff7011c06758b8296fce4cdf9.jpeg)

Hi Jeff, Thank you for the reply.

So I can successfully get this to work after some trial and error if only ONE tag is selected in the original form. If I select multiple tags the relation stops working.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 10, 2022, 2:29am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/4 "2022-07-10T02:29:42Z")

</div>

To make it work with multiple tags, you would need to use a Split Text column to coerce your tags into an array, and then use that to form the relation.

---

<div class="post-metadata">

**Author:** ![PJnotDJ](https://avatars.discourse-cdn.com/v4/letter/p/9fc29f/32.png) [@PJnotDJ](https://community.glideapps.com/u/PJnotDJ)\
**Post date:** [July 10, 2022, 2:33am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/5 "2022-07-10T02:33:40Z")

</div>

Are you able to elaborate on this just a little more. Are you saying that my tags column needs to be recreated as a Slice Array? Then create the relation?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 10, 2022, 2:36am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/6 "2022-07-10T02:36:35Z")

</div>

No. I was assuming that your tag column is a comma separated list of values, that’s populated by a choice component in multi-select mode. If that assumption is correct, then all you need to do is create the extra column that I described and use that column in the multiple relation.

---

<div class="post-metadata">

**Author:** ![PJnotDJ](https://avatars.discourse-cdn.com/v4/letter/p/9fc29f/32.png) [@PJnotDJ](https://community.glideapps.com/u/PJnotDJ)\
**Post date:** [July 10, 2022, 2:39am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/7 "2022-07-10T02:39:18Z")

</div>

Ok I just want to make sure I understand.

I will make another tags column next to my existing one and then create a second relation column on top of that?

Also your assumption is correct

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 10, 2022, 2:41am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/8 "2022-07-10T02:41:50Z")

</div>

No, just create a Split Text column, point it to you existing column of selected choices, then change the relation to use that Split Text column.

---

<div class="post-metadata">

**Author:** ![PJnotDJ](https://avatars.discourse-cdn.com/v4/letter/p/9fc29f/32.png) [@PJnotDJ](https://community.glideapps.com/u/PJnotDJ)\
**Post date:** [July 10, 2022, 2:46am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/9 "2022-07-10T02:46:53Z")

</div>

Thank you Jeff and Darren. This worked. I am really appreciated of the support from this community. Even though my questions maybe laughable and the easiest things I’m learning so much. Thank you again.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 10, 2022, 2:48am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/10 "2022-07-10T02:48:48Z")

</div>

It took me at least 3 months to figure out what a split text column is useful for, so you’re way ahead of me 😉

---

<div class="post-metadata">

**Author:** ![PJnotDJ](https://avatars.discourse-cdn.com/v4/letter/p/9fc29f/32.png) [@PJnotDJ](https://community.glideapps.com/u/PJnotDJ)\
**Post date:** [July 10, 2022, 2:49am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/11 "2022-07-10T02:49:44Z")

</div>

Well, I’ve got that going for me!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 11, 2022, 2:50am UTC](https://community.glideapps.com/t/unable-to-get-relations-to-work/44212/12 "2022-07-11T02:50:10Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
