# Lookup for multiple relations at PostgreSQL

**URL:** <https://community.glideapps.com/t/lookup-for-multiple-relations-at-postgresql/76087>\
**Category:** Ask for Help\
**Created:** [September 3, 2024, 9:17am UTC](https://community.glideapps.com/t/lookup-for-multiple-relations-at-postgresql/76087 "2024-09-03T09:17:11Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ericho](https://avatars.discourse-cdn.com/v4/letter/e/7bcc69/32.png) [@ericho](https://community.glideapps.com/u/ericho)\
**Post date:** [September 3, 2024, 9:17am UTC](https://community.glideapps.com/t/lookup-for-multiple-relations-at-postgresql/76087/1 "2024-09-03T09:17:11Z")

</div>

Hi,

How to resolve lookup for multiple relations at PostgreSQL?

Thank you.

![Multiple_relation](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/3141e7433e31297497ec702430b65cfbd5af907e.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:** [September 3, 2024, 9:19am UTC](https://community.glideapps.com/t/lookup-for-multiple-relations-at-postgresql/76087/2 "2024-09-03T09:19:43Z")

</div>

Need more information. What is the result you are looking for?

---

<div class="post-metadata">

**Author:** ![ericho](https://avatars.discourse-cdn.com/v4/letter/e/7bcc69/32.png) [@ericho](https://community.glideapps.com/u/ericho)\
**Post date:** [September 4, 2024, 1:59am UTC](https://community.glideapps.com/t/lookup-for-multiple-relations-at-postgresql/76087/3 "2024-09-04T01:59:13Z")

</div>

Hi Darren\_Murphy.

The relation between locations table and robots table is one to many. That means one location could have more than one robot. At locations table, I create a relation with robots table through location id. I would like to have robots name through Lookup at locations table. Please assist.

Thank you.

---

<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:** [September 4, 2024, 6:35am UTC](https://community.glideapps.com/t/lookup-for-multiple-relations-at-postgresql/76087/4 "2024-09-04T06:35:07Z")

</div>

I see you are using a Single Value column to get the robot name. Is that not working for you? What are you expecting to set as a result?

---

<div class="post-metadata">

**Author:** ![ericho](https://avatars.discourse-cdn.com/v4/letter/e/7bcc69/32.png) [@ericho](https://community.glideapps.com/u/ericho)\
**Post date:** [September 4, 2024, 6:50am UTC](https://community.glideapps.com/t/lookup-for-multiple-relations-at-postgresql/76087/5 "2024-09-04T06:50:03Z")

</div>

Hi Jeff\_Hager,

I would like to get multiple robots name for one location. Thank you.

---

<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:** [September 4, 2024, 6:50am UTC](https://community.glideapps.com/t/lookup-for-multiple-relations-at-postgresql/76087/6 "2024-09-04T06:50:52Z")

</div>

Use a Joined List column.

---

<div class="post-metadata">

**Author:** ![ericho](https://avatars.discourse-cdn.com/v4/letter/e/7bcc69/32.png) [@ericho](https://community.glideapps.com/u/ericho)\
**Post date:** [September 6, 2024, 8:08am UTC](https://community.glideapps.com/t/lookup-for-multiple-relations-at-postgresql/76087/7 "2024-09-06T08:08:35Z")

</div>

Thank you 🙂