# Show Relation fields

**URL:** <https://community.glideapps.com/t/show-relation-fields/73839>\
**Category:** Ask for Help\
**Created:** [June 3, 2024, 4:14pm UTC](https://community.glideapps.com/t/show-relation-fields/73839 "2024-06-03T16:14:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![AxelG](https://avatars.discourse-cdn.com/v4/letter/a/d2c977/32.png) [@AxelG](https://community.glideapps.com/u/AxelG)\
**Post date:** [June 3, 2024, 4:14pm UTC](https://community.glideapps.com/t/show-relation-fields/73839/1 "2024-06-03T16:14:25Z")

</div>

Trying to figure this one out.  
I have a data table which shows all our caught fish (fishing club)

In that data table I made a relation field to lookup the person who caught the fish, and the name of the fish (Yes I know, name of the fish, we carp fishermen are bit of a strange breed 🙂 )  
So now I want to display that data .  
But in the Field I have available I can only show the ID field ?  
I’ve added some screenshots where you can see the ID in the title, also added is the screenschot of the DataTable where I indicated the number (ID\_Vis ) and next to it the Rel\_Vis which I would like to display .  
How can I set that one up ?

Many thanks

 ![VisID](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/e/9e70d211542ac1a53b97df384c70e953c9c68e7d.jpeg)  
 ![Visser](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c9b50af9288ae70f1b93deaa6ca50ca01b7585b2.png)

---

<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:** [June 3, 2024, 8:24pm UTC](https://community.glideapps.com/t/show-relation-fields/73839/2 "2024-06-03T20:24:23Z")

</div>

Make sure your relation is a single relation and doesn’t have the Multiple checkbox checked if you are only expecting a single matching record.

---

<div class="post-metadata">

**Author:** ![AxelG](https://avatars.discourse-cdn.com/v4/letter/a/d2c977/32.png) [@AxelG](https://community.glideapps.com/u/AxelG)\
**Post date:** [June 4, 2024, 10:05am UTC](https://community.glideapps.com/t/show-relation-fields/73839/3 "2024-06-04T10:05:14Z")

</div>

It should be single relation

 ![Rel Vis](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6fb94ac75bce201cd792eb6ff597eedbda70c48f.png)  
 ![Vis](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d33d2f9acd1786fda8a43262f5e6c44dce2a744.jpeg)

In the Table VANGSTEN, it looks up the ID in the Table VISSEN, (row284 linked to yellow line)  
So I would like to make that lookup visible in the app

---

<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:** [June 4, 2024, 10:35am UTC](https://community.glideapps.com/t/show-relation-fields/73839/4 "2024-06-04T10:35:17Z")

</div>

Is your Lookup column using that relation? Show me how the lookup column is configured. If the lookup column is coming back as an array instead of a single value, then either your lookup is looking at the wrong relation or it’s looking at an entire table, or it’s bringing back an array type column from the related row.

---

<div class="post-metadata">

**Author:** ![AxelG](https://avatars.discourse-cdn.com/v4/letter/a/d2c977/32.png) [@AxelG](https://community.glideapps.com/u/AxelG)\
**Post date:** [June 4, 2024, 12:02pm UTC](https://community.glideapps.com/t/show-relation-fields/73839/5 "2024-06-04T12:02:53Z")

</div>

Ok, that reply made a lot clear to me.

In fact I thought it was OK as I had the Rel\_VIs colomn were I saw the name that I wanted to use, But I was missing a lookup which I now added VISNAAM (shown in Yellow) which indeed I can now use.

Many thansk

 ![QGHoUQsi2O](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/c/1cbcdcdcabdf1d5a50cc6bef4d1011a2bc8c6738.png)

---

<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:** [June 11, 2024, 12:03pm UTC](https://community.glideapps.com/t/show-relation-fields/73839/6 "2024-06-11T12:03:28Z")

</div>

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