# Relations view when using sheets

**URL:** <https://community.glideapps.com/t/relations-view-when-using-sheets/67924>\
**Category:** Ask for Help\
**Created:** [November 18, 2023, 4:19pm UTC](https://community.glideapps.com/t/relations-view-when-using-sheets/67924 "2023-11-18T16:19:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Muaaz\_Bayat1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muaaz_bayat1/32/66630_2.png) [@Muaaz\_Bayat1](https://community.glideapps.com/u/Muaaz_Bayat1)\
**Post date:** [November 18, 2023, 4:19pm UTC](https://community.glideapps.com/t/relations-view-when-using-sheets/67924/1 "2023-11-18T16:19:30Z")

</div>

I am using sheets as the data source, I am able to create a relation based on foreign keys. I am struggling to get the view to display a field using the relation.  
This is the data:

 ![Screenshot from 2023-11-18 18-16-21](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2abee9e7fd67bf27e9193da222af3556bb888f73.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd94b1a779c98a52837d4370eb77b7e3d5b8bc60.png)

This is the view which isnt showing the relation column:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/ba5c1c3c8742bd2191d9c5afedcb503015a32218.png)  
I would like the list to use the job title based on the matching job\_id

Please help in this regard, All suggestions are greatly appreciated.

---

<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 18, 2023, 4:23pm UTC](https://community.glideapps.com/t/relations-view-when-using-sheets/67924/2 "2023-11-18T16:23:54Z")

</div>

Relations are links to entire rows of data. If you want to pull a specific column value out of that relation, you also need a Lookup column that uses that relation.

---

<div class="post-metadata">

**Author:** ![Muaaz\_Bayat1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muaaz_bayat1/32/66630_2.png) [@Muaaz\_Bayat1](https://community.glideapps.com/u/Muaaz_Bayat1)\
**Post date:** [November 18, 2023, 4:47pm UTC](https://community.glideapps.com/t/relations-view-when-using-sheets/67924/3 "2023-11-18T16:47:21Z")

</div>

You’re a lifesaver dude. TX a ton!

---

<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 25, 2023, 4:48pm UTC](https://community.glideapps.com/t/relations-view-when-using-sheets/67924/4 "2023-11-25T16:48:09Z")

</div>

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