# Look up issue whereas relation in place

**URL:** <https://community.glideapps.com/t/look-up-issue-whereas-relation-in-place/67681>\
**Category:** Ask for Help\
**Created:** [November 10, 2023, 9:25pm UTC](https://community.glideapps.com/t/look-up-issue-whereas-relation-in-place/67681 "2023-11-10T21:25:39Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![hugoszz](https://avatars.discourse-cdn.com/v4/letter/h/bbce88/32.png) [@hugoszz](https://community.glideapps.com/u/hugoszz)\
**Post date:** [November 10, 2023, 9:25pm UTC](https://community.glideapps.com/t/look-up-issue-whereas-relation-in-place/67681/1 "2023-11-10T21:25:39Z")

</div>

hello team  
I have 2 tables (A and B). my relation is in place between the two tables. the relation is a name.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c1c583dd0c29e3539cc9221adf07420bf9a1e6cf.png)

I’ve created a look up column that would set a value from table A into table B but the output given is all the value present in that column in all the table A. just like if there were no relation in place.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/352b10a324c9808228cd0f3811144b4da55c969b.png)

I’ve done the tuto multiple time without success. I’ve watch the video. I’m doing the exact same thing : [Lookup](https://www.glideapps.com/docs/automation/computed-columns/lookup-column)

can you help me please ?

---

<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:** [November 10, 2023, 9:32pm UTC](https://community.glideapps.com/t/look-up-issue-whereas-relation-in-place/67681/2 "2023-11-10T21:32:43Z")

</div>

Make sure the Lookup column in using the Relation. Not the Table.

Notice how the tutorial is showing to select the relation.

 ![Screenshot_20231110-153726](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52ace8519107a08104aae8e9be75da04d6c73f34.jpeg)

---

<div class="post-metadata">

**Author:** ![hugoszz](https://avatars.discourse-cdn.com/v4/letter/h/bbce88/32.png) [@hugoszz](https://community.glideapps.com/u/hugoszz)\
**Post date:** [November 13, 2023, 5:05am UTC](https://community.glideapps.com/t/look-up-issue-whereas-relation-in-place/67681/3 "2023-11-13T05:05:53Z")

</div>

thanks a lot, you solved my issue.  
just one more question: the output of the look up is en email address as you see here :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/48a53efdb4060b21f9663dbf283b8f1a0c092df0.png)

I would like to send an email with it, but the column doesn’t appear in the email action :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c7f7cf74770086c82acea290021feb8b42ffc46.png)

the format of the initial column (where the look up comes from) is e-mail.  
is it possible to use the data from a look up ?  
thx

---

<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:** [November 13, 2023, 5:25am UTC](https://community.glideapps.com/t/look-up-issue-whereas-relation-in-place/67681/4 "2023-11-13T05:25:24Z")

</div>

Your lookup is returning an array, which suggests that your relation is a _multiple_ relation.  
If you want to use the lookup in that way, then your relation must be a _single_ relation.

---

<div class="post-metadata">

**Author:** ![hugoszz](https://avatars.discourse-cdn.com/v4/letter/h/bbce88/32.png) [@hugoszz](https://community.glideapps.com/u/hugoszz)\
**Post date:** [November 13, 2023, 7:11am UTC](https://community.glideapps.com/t/look-up-issue-whereas-relation-in-place/67681/5 "2023-11-13T07:11:04Z")

</div>

indeed, it works ! thanks a lot !!

---

<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:** [November 20, 2023, 7:11am UTC](https://community.glideapps.com/t/look-up-issue-whereas-relation-in-place/67681/6 "2023-11-20T07:11:41Z")

</div>

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