# Lookup problem

**URL:** <https://community.glideapps.com/t/lookup-problem/30536>\
**Category:** Ask for Help\
**Created:** [August 16, 2021, 11:35am UTC](https://community.glideapps.com/t/lookup-problem/30536 "2021-08-16T11:35:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![baremeter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/baremeter/32/28090_2.png) [@baremeter](https://community.glideapps.com/u/baremeter)\
**Post date:** [August 16, 2021, 11:35am UTC](https://community.glideapps.com/t/lookup-problem/30536/1 "2021-08-16T11:35:47Z")

</div>

I want to fetch the First name from my list All Agents Table based on the email address they have entered on the login page (Profile Table)  
I have set up a relation column that links the “actual email” with “email” in the All Agents Table.  
The I use a lookup column that (should) pull the individual first name from the All Agents Table.  
What it does is to bring up all of the agents first names in a horizontal format.  
Also, why isn the Relation column does it choose an ID column and places a photo in there too - I realise that it has to index something but it picked this column without asking is it because it is headed ID and is that the problem …?

 ![Screenshot 2021-08-16 at 13.20.23](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/9446bf8bd2bed40b2b982ac1d3725b145547b5f6.jpeg)

 ![Screenshot 2021-08-16 at 13.20.40](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/86f39e95457b5384b6eeaedbb9204166b6cd8fce.png)

 ![Screenshot 2021-08-16 at 13.34.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/181c1df4ac5d293a30c27cdfd92e3bcd373d3830.png)

---

<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:** [August 16, 2021, 12:22pm UTC](https://community.glideapps.com/t/lookup-problem/30536/2 "2021-08-16T12:22:18Z")

</div>

Your lookup column isn’t using the relation that you created. It’s using the whole sheet instead. Change it to use the relation.

It doesn’t matter what a relation column picks to show you. A relation is a row or series of rows. It’s not a single column. As long as you see something in there, then you know it found matching rows.

---

<div class="post-metadata">

**Author:** ![baremeter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/baremeter/32/28090_2.png) [@baremeter](https://community.glideapps.com/u/baremeter)\
**Post date:** [August 16, 2021, 12:28pm UTC](https://community.glideapps.com/t/lookup-problem/30536/3 "2021-08-16T12:28:30Z")

</div>

Magic!

Thanks

Mike

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/lookup-problem/30536/4 "2024-01-17T16:50:54Z")

</div>