# Issue with Lookup

**URL:** https://community.glideapps.com/t/issue-with-lookup/2614
**Category:** Report a Bug
**Created:** [December 4, 2019, 2:05pm UTC](https://community.glideapps.com/t/issue-with-lookup/2614 "2019-12-04T14:05:05Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [December 4, 2019, 2:05pm UTC](https://community.glideapps.com/t/issue-with-lookup/2614/1 "2019-12-04T14:05:05Z")

</div>

I’m having an issue getting a Lookup to show up properly. It may be because it’s a 2nd lookup column. My 2nd lookup column is showing as a Relation and not a Lookup (I have confirmed that it is a lookup).

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/ab2737101cdd7514a3f28f2862694b70b6935fa2.png)

\*\* See last column called “Lookup Player Name”… it should be a Lookup column type and it’s showing as a Relation. Actually, so is the “Lookup Name” column — it should also be a Lookup and not a relation. Can you only have one Lookup column per sheet?

---

<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: [December 4, 2019, 2:37pm UTC](https://community.glideapps.com/t/issue-with-lookup/2614/2 "2019-12-04T14:37:03Z")

</div>

If it still functions as a Lookup, then you should be fine. I think the little icon for relation shows up on any column that has an array of multiple values. Are you expecting only one value to show in your lookup column or to have multiple values? How are you trying to use the column in your app? Is this just a cosmetic issue, or is something not working in your app?

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [December 4, 2019, 2:38pm UTC](https://community.glideapps.com/t/issue-with-lookup/2614/3 "2019-12-04T14:38:37Z")

</div>

When I try to add the Lookup values to my app, they don’t show up in my list of possible fields because they’re being seen as Relation columns and not Lookups. The first Lookup column does show up, but not the 2nd and 3rd.

---

<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: [December 4, 2019, 2:44pm UTC](https://community.glideapps.com/t/issue-with-lookup/2614/4 "2019-12-04T14:44:52Z")

</div>

I think it’s because the lookup is tied to a relation with ‘multiple’ checked. Your lookup is pulling back multiple values and I assume you are trying to add it to a single value component.

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [December 4, 2019, 3:17pm UTC](https://community.glideapps.com/t/issue-with-lookup/2614/5 "2019-12-04T15:17:02Z")

</div>

Ooo you may be right. I guess LOOKUP won’t work for me in this case as I need to pull in multiple values.

---

<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: [December 4, 2019, 3:29pm UTC](https://community.glideapps.com/t/issue-with-lookup/2614/6 "2019-12-04T15:29:34Z")

</div>

If you are just trying to get a list of names, I would just use your relation for a compact inline list with no action selected.

---

<div class="post-metadata">

### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [December 4, 2019, 3:33pm UTC](https://community.glideapps.com/t/issue-with-lookup/2614/7 "2019-12-04T15:33:34Z")

</div>

Glide currently shows the Relation icon for any computed column. Sorry about the confusion - we’ll fix this soon.

---

<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: [May 11, 2024, 6:08am UTC](https://community.glideapps.com/t/issue-with-lookup/2614/8 "2024-05-11T06:08:26Z")

</div>


