# Relations column not work **URL:** https://community.glideapps.com/t/relations-column-not-work/38687 **Category:** Ask for Help **Created:** [February 18, 2022, 8:58pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687 "2022-02-18T20:58:52Z") **Posts on this page:** 12 **Page:** 1
### Author: ![Paola\_Lombardi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paola_lombardi/32/39250_2.png) [@Paola\_Lombardi](https://community.glideapps.com/u/Paola_Lombardi) #### Post date: [February 18, 2022, 8:58pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/1 "2022-02-18T20:58:52Z")
I can’t create a relations column! where am i wrong? ![Schermata 2022-02-18 alle 21.54.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/92261c86943f957f86041eab85c3d36b08c90d62.png) ---
### 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: [February 18, 2022, 9:02pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/2 "2022-02-18T21:02:44Z")
Are you trying to match an email to a name? Both values need to match for a relation to work. You should be linking email to email. ---
### Author: ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez) #### Post date: [February 18, 2022, 9:09pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/3 "2022-02-18T21:09:13Z")
Adding to what @Jeff_Hager said, it seems that your email columns are text columns. It is recommended that your email columns be formatted as emails. To do that, hover over the header, click on the downward arrow \> edit \> column type \> email. ---
### 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: [February 18, 2022, 9:34pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/4 "2022-02-18T21:34:26Z")
> [@SantiagoPerez](#): > > email columns be formatted as emails Just for my knowledge, does this allow emails to be compare regardless of uppercase or lowercase? ---
### Author: ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez) #### Post date: [February 18, 2022, 9:58pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/5 "2022-02-18T21:58:06Z")
No, it does not. ☹ ![Screen Shot 2022-02-18 at 3.57.22 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d187070d3de48cee75617e6ae8bed88fd9ca5e14.png) ---
### 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: [February 18, 2022, 10:11pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/6 "2022-02-18T22:11:06Z")
OK, just curious if I had missed a feature since you mentioned changing it to an email column. ---
### Author: ![Paola\_Lombardi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paola_lombardi/32/39250_2.png) [@Paola\_Lombardi](https://community.glideapps.com/u/Paola_Lombardi) #### Post date: [February 20, 2022, 5:58pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/7 "2022-02-20T17:58:41Z")
![Schermata 2022-02-20 alle 18.51.09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3dede63a9a2e1682932e4bce8b24a62fc6e49428.png) i changed but it doesn’t work ☹ ---
### Author: ![Paola\_Lombardi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paola_lombardi/32/39250_2.png) [@Paola\_Lombardi](https://community.glideapps.com/u/Paola_Lombardi) #### Post date: [February 20, 2022, 6:00pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/8 "2022-02-20T18:00:52Z")
in this example it works! ![Schermata 2022-02-20 alle 19.00.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f10568aa24a7cb7454f26c59e50241e3fc21cece.png) ---
### Author: ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy) #### Post date: [February 20, 2022, 6:14pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/9 "2022-02-20T18:14:30Z")
Ciao @Paola_Lombardi se ad ogni utente fanno capo più transazioni allora devi impostare una relazione multipla. ---
### Author: ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera) #### Post date: [February 20, 2022, 6:54pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/10 "2022-02-20T18:54:24Z")
There is a no match with the two email columns values in the two tables and then the relation becomes empty because there is no match. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/e/1e5f59d103a82a9daa182cb3b17ff80694fe62f0.png) ---
### 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: [February 20, 2022, 7:05pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/11 "2022-02-20T19:05:41Z")
Based on the screenshot, there aren’t any matches between the two email columns. I wasn’t able to see any email addresses that existed in both columns. The column will certainly be empty if there isn’t a match. ---
### 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: [February 21, 2022, 7:06pm UTC](https://community.glideapps.com/t/relations-column-not-work/38687/12 "2022-02-21T19:06:03Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.