Lookup for multiple relations at PostgreSQL

Ask for Help
1

Hi,

How to resolve lookup for multiple relations at PostgreSQL?

Thank you.

Multiple_relation

2

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

1 Like
3

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.

4

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?

5

Hi Jeff_Hager,

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

6

Use a Joined List column.

2 Likes
7

Thank you :slight_smile: