# Looked up Fields Not Available to Display

**URL:** <https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395>\
**Category:** Ask for Help\
**Created:** [November 11, 2021, 2:06pm UTC](https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395 "2021-11-11T14:06:25Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Juan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan/32/33153_2.png) [@Juan](https://community.glideapps.com/u/Juan)\
**Post date:** [November 11, 2021, 2:06pm UTC](https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395/1 "2021-11-11T14:06:25Z")

</div>

Hello, I have created a relationship column and then pulled some fields to the sheet from other via such just created relationship using look-up field crating new columns.

However such fields do not seem to be available for displaying either at the tab-list level or the details level. What I could be doing wrong?  
Thanks !!  
Juan

 ![chrome_kpWy6WO0Cz](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3d4a8f27e30cc538aec91538b4b4b804c271608.png)  
 ![mspaint_CGVz0uNna3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c07c1b084f86e773ed4ff13a4fb76fda0cd5566.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:** [November 11, 2021, 2:08pm UTC](https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395/2 "2021-11-11T14:08:50Z")

</div>

Is your relation a single or a multi-relation?

---

<div class="post-metadata">

**Author:** ![Juan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan/32/33153_2.png) [@Juan](https://community.glideapps.com/u/Juan)\
**Post date:** [November 11, 2021, 2:39pm UTC](https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395/3 "2021-11-11T14:39:03Z")

</div>

That’s kind of weird, it is multiple, which makes no sense as one record should match only one project number, but when I set it up for single does not pull anything into the column, it does not make logical sense as if multiple pulls one, single should pull the same. Right? Thanks !!

---

<div class="post-metadata">

**Author:** ![Juan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan/32/33153_2.png) [@Juan](https://community.glideapps.com/u/Juan)\
**Post date:** [November 11, 2021, 2:45pm UTC](https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395/4 "2021-11-11T14:45:21Z")

</div>

I made a quick video showing the problem I have, thanks again for your kind help!!

---

<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 11, 2021, 2:47pm UTC](https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395/5 "2021-11-11T14:47:31Z")

</div>

It should be a single relation, but after you switch it to single, try to recreate your lookup column.

---

<div class="post-metadata">

**Author:** ![Juan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan/32/33153_2.png) [@Juan](https://community.glideapps.com/u/Juan)\
**Post date:** [November 11, 2021, 5:28pm UTC](https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395/6 "2021-11-11T17:28:47Z")

</div>

Thanks Jeff, recreated the relationship as single, and lookups and it worked fine, thanks again!!!

---

<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 11, 2021, 5:43pm UTC](https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395/7 "2021-11-11T17:43:54Z")

</div>

Good to hear. I don’t know why, but it seems like, on rare occasions, switching a relation between multiple and single will cause issues with a Lookup column. I don’t know why, but recreating everything usually works.

---

<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 12, 2021, 5:44pm UTC](https://community.glideapps.com/t/looked-up-fields-not-available-to-display/34395/8 "2021-11-12T17:44:48Z")

</div>

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