# Relação **URL:** \ **Category:** Ask for Help\ **Created:** [January 20, 2025, 8:24pm UTC](https://community.glideapps.com/t/relacao/79358 "2025-01-20T20:24:01Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Isael\_Rocha\_Cunha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isael_rocha_cunha/32/80897_2.png) [@Isael\_Rocha\_Cunha](https://community.glideapps.com/u/Isael_Rocha_Cunha)\ **Post date:** [January 20, 2025, 8:24pm UTC](https://community.glideapps.com/t/relacao/79358/1 "2025-01-20T20:24:01Z")
The **CATEGORIES** column is in the first table, where it has the values 1 and 2. In the second table, there is a column called **PRODUCTS** , where the products are listed, and another column called **CATEGORIES** , with the corresponding values from table 1. Even so, it doesn’t work. Why is the relationship not working? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 20, 2025, 11:50pm UTC](https://community.glideapps.com/t/relacao/79358/2 "2025-01-20T23:50:44Z")
Can you specify what exactly is not working, with screenshots as well? ---
**Author:** ![Isael\_Rocha\_Cunha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isael_rocha_cunha/32/80897_2.png) [@Isael\_Rocha\_Cunha](https://community.glideapps.com/u/Isael_Rocha_Cunha)\ **Post date:** [January 21, 2025, 2:55pm UTC](https://community.glideapps.com/t/relacao/79358/3 "2025-01-21T14:55:54Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d87eb5cc737909bd89575495d86e85a723e3f722.png) This is the first table, with the “CATEGORIA” column in Portuguese. The column contains “1” and “2”. ---
**Author:** ![Isael\_Rocha\_Cunha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isael_rocha_cunha/32/80897_2.png) [@Isael\_Rocha\_Cunha](https://community.glideapps.com/u/Isael_Rocha_Cunha)\ **Post date:** [January 21, 2025, 3:01pm UTC](https://community.glideapps.com/t/relacao/79358/4 "2025-01-21T15:01:50Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a6a1f2cd4bea223e3c61eb182040d8aad33fe4ee.png) This is the second table with two columns: one named “CATEGORIES,” which contains “1” and “2,” and the second named “PRODUCTS,” which I wanted to relate. ---
**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:** [January 21, 2025, 3:03pm UTC](https://community.glideapps.com/t/relacao/79358/5 "2025-01-21T15:03:44Z")
Where is your relation? I don’t see a relation column. ---
**Author:** ![Isael\_Rocha\_Cunha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isael_rocha_cunha/32/80897_2.png) [@Isael\_Rocha\_Cunha](https://community.glideapps.com/u/Isael_Rocha_Cunha)\ **Post date:** [January 21, 2025, 5:19pm UTC](https://community.glideapps.com/t/relacao/79358/6 "2025-01-21T17:19:01Z")
Just a moment, I’ll try to add it. ---
**Author:** ![Isael\_Rocha\_Cunha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isael_rocha_cunha/32/80897_2.png) [@Isael\_Rocha\_Cunha](https://community.glideapps.com/u/Isael_Rocha_Cunha)\ **Post date:** [January 21, 2025, 5:21pm UTC](https://community.glideapps.com/t/relacao/79358/7 "2025-01-21T17:21:41Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e8283a35e523fbfa90974347c45f56f20f8ffbab.png) When I try to add the relation column, this appears. ---
**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:** [January 21, 2025, 5:31pm UTC](https://community.glideapps.com/t/relacao/79358/8 "2025-01-21T17:31:20Z")
After saving the relation and clicking on the query button in each row, do you see a result? Seems correct to me considering you are using big tables. You might want to select the Match Multiple checkbox since you are doing a one to many relation with multiple matches. ---
**Author:** ![Isael\_Rocha\_Cunha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isael_rocha_cunha/32/80897_2.png) [@Isael\_Rocha\_Cunha](https://community.glideapps.com/u/Isael_Rocha_Cunha)\ **Post date:** [January 21, 2025, 5:35pm UTC](https://community.glideapps.com/t/relacao/79358/9 "2025-01-21T17:35:48Z")
I am relating the “CATEGORIES” column from the “previous-milk” table, where the numbers “1” and “2” are present, to the “CATEGORIES” column in the “affectionate-table” table, where “1” and “2” also appear, but in greater quantity. Am I doing the relation incorrectly? ---
**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:** [January 21, 2025, 5:36pm UTC](https://community.glideapps.com/t/relacao/79358/10 "2025-01-21T17:36:55Z")
Yep, I understand what you are doing. Like I said: > [@Jeff\_Hager](#): > > You might want to select the Match Multiple checkbox since you are doing a one to many relation with multiple matches. Other than that, I don’t see a problem. ---
**Author:** ![Isael\_Rocha\_Cunha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isael_rocha_cunha/32/80897_2.png) [@Isael\_Rocha\_Cunha](https://community.glideapps.com/u/Isael_Rocha_Cunha)\ **Post date:** [January 21, 2025, 5:39pm UTC](https://community.glideapps.com/t/relacao/79358/11 "2025-01-21T17:39:05Z")
It worked, thank you very much! Now I’ll scale it up, and if I need help again, I’ll come back here. ---
**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:** [January 28, 2025, 5:39pm UTC](https://community.glideapps.com/t/relacao/79358/12 "2025-01-28T17:39:57Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.