# Lookup column not displaying in layout

**URL:** https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538
**Category:** Ask for Help
**Created:** [March 9, 2024, 4:45am UTC](https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538 "2024-03-09T04:45:45Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Jorge\_Borges](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jorge_borges/32/36879_2.png) [@Jorge\_Borges](https://community.glideapps.com/u/Jorge_Borges)
#### Post date: [March 9, 2024, 4:45am UTC](https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538/1 "2024-03-09T04:45:45Z")

</div>

I am trying to get the data from a lookup column to display in my layout but it will not display. I’ve created a relationship between one data table and another and then used that relationship to create a lookup column. The lookup data shows up in the database but will not display on the layout. Any ideas?

 ![Screenshot 2024-03-08 at 11.43.37 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/15aa17032c7e7d9eb652f61e057c547b3dc39ce9.png)  
Lookup information shows in the table above, but not in the data table below or in the user screen that I am building.

 ![Screenshot 2024-03-08 at 11.44.58 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d38dfd1108edbb65cb733f88c9f61202420f299a.png)

---

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [March 9, 2024, 5:36am UTC](https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538/2 "2024-03-09T05:36:21Z")

</div>

You could try changing your relation to ‘Single’ instead of match multiple.

---

<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: [March 9, 2024, 6:45am UTC](https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538/3 "2024-03-09T06:45:59Z")

</div>

If you are able to choose the lookup column, and the lookup doesn’t appear as an array in the data, then the relation should already be a single relation.

I’m more inclined to say that the Operator table has Row Owners applied, and the current user is not the owner of the row that the relation is attempting to connect to.

---

<div class="post-metadata">

### Author: ![Jorge\_Borges](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jorge_borges/32/36879_2.png) [@Jorge\_Borges](https://community.glideapps.com/u/Jorge_Borges)
#### Post date: [March 9, 2024, 8:53pm UTC](https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538/5 "2024-03-09T20:53:00Z")

</div>

> [@Eric\_Penn](#):
>
> hanging your relation to ‘Single’ instead of match multiple.

How do I do that?

---

<div class="post-metadata">

### Author: ![Jorge\_Borges](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jorge_borges/32/36879_2.png) [@Jorge\_Borges](https://community.glideapps.com/u/Jorge_Borges)
#### Post date: [March 9, 2024, 8:54pm UTC](https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538/6 "2024-03-09T20:54:40Z")

</div>

Yes, Row Owner is applied. I didn’t know what _row owners_ did. Let me try and remove it to see if it resolves the issue.

---

<div class="post-metadata">

### Author: ![Jorge\_Borges](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jorge_borges/32/36879_2.png) [@Jorge\_Borges](https://community.glideapps.com/u/Jorge_Borges)
#### Post date: [March 9, 2024, 8:57pm UTC](https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538/7 "2024-03-09T20:57:22Z")

</div>

> [@Jeff\_Hager](#):
>
> Row Owners

That did it. I removed the Row Owners function from the Operator table. What does Row Owner do anyway?

---

<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: [March 9, 2024, 9:38pm UTC](https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538/8 "2024-03-09T21:38:16Z")

</div>

Row Owners secures the data. If you have row owners applied then only the rows that a user owns will be downloaded to their device. If you don’t apply row owners, then a user has access to all rows of data in that table.

> **[Row Owners | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/row-owners)**
>
> A secure way to restrict access to certain rows.

---

<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: [March 16, 2024, 9:39pm UTC](https://community.glideapps.com/t/lookup-column-not-displaying-in-layout/71538/9 "2024-03-16T21:39:03Z")

</div>

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