# Relation column in Data Editor displays matches as ROW ID rather than Name

**URL:** <https://community.glideapps.com/t/relation-column-in-data-editor-displays-matches-as-row-id-rather-than-name/12307>\
**Category:** Ask for Help\
**Created:** [July 11, 2020, 2:28pm UTC](https://community.glideapps.com/t/relation-column-in-data-editor-displays-matches-as-row-id-rather-than-name/12307 "2020-07-11T14:28:13Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\
**Post date:** [July 11, 2020, 2:28pm UTC](https://community.glideapps.com/t/relation-column-in-data-editor-displays-matches-as-row-id-rather-than-name/12307/1 "2020-07-11T14:28:13Z")

</div>

Simple relation in a Location tab that relates all employees to their locations, returns the ROW ID when matching, rather than the names. This is making it hard to check if the relation are as intended.

 ![Screen Shot 2020-07-11 at 10.03.48 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4cb74048e34c2abced49c1ede2a452a318da642a.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 11, 2020, 2:32pm UTC](https://community.glideapps.com/t/relation-column-in-data-editor-displays-matches-as-row-id-rather-than-name/12307/2 "2020-07-11T14:32:43Z")

</div>

The relation returns the first column of the sheet you’re trying to match your data to, it shows you that “Yeah we find something that matches your condition”.

To actually return the values you want, use a lookup on that relation.

---

<div class="post-metadata">

**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\
**Post date:** [July 11, 2020, 2:33pm UTC](https://community.glideapps.com/t/relation-column-in-data-editor-displays-matches-as-row-id-rather-than-name/12307/3 "2020-07-11T14:33:36Z")

</div>

That’s interesting. I watched the Employees App tutorial which said to use the relation. Still learning which column types work best. Thanks!

---

<div class="post-metadata">

**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\
**Post date:** [July 11, 2020, 2:34pm UTC](https://community.glideapps.com/t/relation-column-in-data-editor-displays-matches-as-row-id-rather-than-name/12307/4 "2020-07-11T14:34:15Z")

</div>

How does using the Lookup vs. the Relation affect ability to then use inline lists based on relation?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 11, 2020, 2:36pm UTC](https://community.glideapps.com/t/relation-column-in-data-editor-displays-matches-as-row-id-rather-than-name/12307/5 "2020-07-11T14:36:09Z")

</div>

It does not affect anything. If you don’t want to actually do anything further than showing matches in an inline list then you’re good to go with those relations.

---

<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:** [July 11, 2020, 2:51pm UTC](https://community.glideapps.com/t/relation-column-in-data-editor-displays-matches-as-row-id-rather-than-name/12307/6 "2020-07-11T14:51:57Z")

</div>

Lookups are used along with relations to return a specific column from that relation.

---

<div class="post-metadata">

**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\
**Post date:** [July 11, 2020, 2:53pm UTC](https://community.glideapps.com/t/relation-column-in-data-editor-displays-matches-as-row-id-rather-than-name/12307/7 "2020-07-11T14:53:51Z")

</div>

Good to point out. I realized this through trial and error just now as well because you cannot add a lookup if no relation exists first.
