# Showing lookup data result from other table

**URL:** <https://community.glideapps.com/t/showing-lookup-data-result-from-other-table/69777>\
**Category:** Ask for Help\
**Created:** [January 20, 2024, 11:26am UTC](https://community.glideapps.com/t/showing-lookup-data-result-from-other-table/69777 "2024-01-20T11:26:44Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lee/32/68882_2.png) [@Lee](https://community.glideapps.com/u/Lee)\
**Post date:** [January 20, 2024, 11:26am UTC](https://community.glideapps.com/t/showing-lookup-data-result-from-other-table/69777/1 "2024-01-20T11:26:44Z")

</div>

Hi All,

I have a set of data on table “MainTask”:

1. TaskName
2. Description  
 ![Screenshot 2024-01-20 at 18.15.43](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/540af41e620c05cda7d3d432b8bc70d740a1f652.png)

and on table “DailyActivity” I have set of data:

1. TaskName
2. RelMainTask (that relate DailyActivity\>TaskName with MainTask\>TaskName)
3. LookupMainTask (Lookup from RelMainTask to MainTask\>Description)  
 ![Screenshot 2024-01-20 at 18.15.36](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/163f72381907c7e22b667539eea1d58d5cf7512e.png)

Now, when I choose something from the TaskName dropdown, I need the text below it to show the content of MainTask\>Description, but the text cannot even read the Lookup result?

 ![Screenshot 2024-01-20 at 18.22.09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb00ebc20a37d169e5faced75387b8778acf5687.png)

Is there anyone who can help/guide me through this? Thank you in advance.

---

<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:** [January 20, 2024, 11:40am UTC](https://community.glideapps.com/t/showing-lookup-data-result-from-other-table/69777/2 "2024-01-20T11:40:55Z")

</div>

Check your relation and make sure it is a single relation.

---

<div class="post-metadata">

**Author:** ![Lee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lee/32/68882_2.png) [@Lee](https://community.glideapps.com/u/Lee)\
**Post date:** [January 20, 2024, 1:07pm UTC](https://community.glideapps.com/t/showing-lookup-data-result-from-other-table/69777/3 "2024-01-20T13:07:08Z")

</div>

![Screenshot 2024-01-20 at 20.05.39](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c483eb9f15a3f6c69739ea743c8b7e8eca81fa3.png)

Single relation means, it’s not a multiple match relation?

---

<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:** [January 20, 2024, 1:12pm UTC](https://community.glideapps.com/t/showing-lookup-data-result-from-other-table/69777/4 "2024-01-20T13:12:19Z")

</div>

When you are in a form, nothing is written to the table until you submit the form, so computed columns, including relations and looks won’t have any values until it’s submitted.

My suggestion is to create a custom collection in the form that is sourced from the main table and set up to only show the description. Remove any actions from the collection. Then set a filter on the collection to only show the row where the Screen Value from the choice component matches the task name in the collection.

---

<div class="post-metadata">

**Author:** ![Lee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lee/32/68882_2.png) [@Lee](https://community.glideapps.com/u/Lee)\
**Post date:** [January 20, 2024, 1:18pm UTC](https://community.glideapps.com/t/showing-lookup-data-result-from-other-table/69777/5 "2024-01-20T13:18:58Z")

</div>

Thank you so much @Jeff_Hager

 ![Screenshot 2024-01-20 at 20.16.53](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f1403e85f3c587ff5a6fe4aad6c57793173513c7.png)  
 ![Screenshot 2024-01-20 at 20.16.59](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ade6775a941884dc7bfcf14d8f0ce440fadfea7f.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:** [January 27, 2024, 1:19pm UTC](https://community.glideapps.com/t/showing-lookup-data-result-from-other-table/69777/6 "2024-01-27T13:19:13Z")

</div>

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