# Multiple relation lookup error

**URL:** <https://community.glideapps.com/t/multiple-relation-lookup-error/57749>\
**Category:** Ask for Help\
**Created:** [February 10, 2023, 8:00am UTC](https://community.glideapps.com/t/multiple-relation-lookup-error/57749 "2023-02-10T08:00:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\
**Post date:** [February 10, 2023, 8:00am UTC](https://community.glideapps.com/t/multiple-relation-lookup-error/57749/1 "2023-02-10T08:00:58Z")

</div>

Hello ,  
I am trying to fetch the emails from the other table through multiple relation but lookup column is not showing any value  
Please see the screenshot

 ![Relation Edit](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/17035670f9816cbd5cfbbbe356c5db0c1b808723.png)  
 ![Relation](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de7a2e25ef8dd514a612bcb398fe5a3902470751.png)

---

<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:** [February 10, 2023, 8:07am UTC](https://community.glideapps.com/t/multiple-relation-lookup-error/57749/2 "2023-02-10T08:07:10Z")

</div>

Your relation is a multiple relation, so any lookup through that would return an array (although your lookup is returning empty, so I suspect it is misconfigured).

Anyway, to get a list of email addresses via that relation, you should use a Joined List column. Ensure that your Joined List is targeting the relation column.

---

<div class="post-metadata">

**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\
**Post date:** [February 10, 2023, 8:12am UTC](https://community.glideapps.com/t/multiple-relation-lookup-error/57749/3 "2023-02-10T08:12:11Z")

</div>

Okay, I used joined list thank you

---

<div class="post-metadata">

**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\
**Post date:** [February 10, 2023, 8:16am UTC](https://community.glideapps.com/t/multiple-relation-lookup-error/57749/4 "2023-02-10T08:16:53Z")

</div>

![credit points](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b5dee8c87f4b944de98ff6a741c2acc39007cb2.png)

Here, both credits and rank are lookup from multiple relations, but why the values representation is not same, ranks are displayed like array values, I want it to be displayed like credits points

---

<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:** [February 10, 2023, 8:24am UTC](https://community.glideapps.com/t/multiple-relation-lookup-error/57749/5 "2023-02-10T08:24:37Z")

</div>

Need more information.  
Please show the source data, as well as how the columns are configured.

Rank is an array, which means it’s either using a multiple relation, or the source data is also an array.