# Lookup column not showing values in collection table **URL:** \ **Category:** Ask for Help\ **Created:** [June 7, 2025, 8:27am UTC](https://community.glideapps.com/t/lookup-column-not-showing-values-in-collection-table/82302 "2025-06-07T08:27:48Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Rob\_Cap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rob_cap/32/87029_2.png) [@Rob\_Cap](https://community.glideapps.com/u/Rob_Cap)\ **Post date:** [June 7, 2025, 8:27am UTC](https://community.glideapps.com/t/lookup-column-not-showing-values-in-collection-table/82302/1 "2025-06-07T08:27:48Z")
Hello, I’ve got troubles with Lookup. I have a 2 tables 1. ‘Users’, with a lot of columns. The relevant ones are Band Name and School Name 2. ‘Bands\_Battle’ with a lot of columns. The relevant one is Band name. I have a layout page “Battle” where I display a collection table, which shows the Band names (source data table: Bands\_Battle). I want to display the School Name next to Band name . To do so I created a relationship column in the data table Bands\_Battle: rel\_Bands\_School. Relate to items where the value in: Band\_Name Matches the value in: Users/Band\_Name Single Then I created a Lookup column: Lkp\_School. Configuration. Relation column: rel\_Bands\_School/School\_Name. ![relation col and Lookup column in Bands_Battle](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/1478153c11eab3c4c7ea599f91343330a86e9f4e.png) The column in the data table displays the correct values. In the layout page, I added the column Lkp\_School to the collection table. It does not display anything. ![In the collection table, the School lookup is not showing up :-(](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/454b3440e9bfc725e57d596fec74e4ff7b9e3c76.png) After numerous trials (and errors), I created a simplified version on a different app, with only the columns I mentioned above. It works perfectly. ![Users table with Band and School](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/afd1cbdffe1b1b11b69b3d723326509f4dfeac21.png) ![Bands_Battle table with the relation and lookup](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/4/04702d24cb71ddfd1319633998a6b79e5b9b65be.png) ![Layout table with Band and School (filtered by Battle)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e65a3bd6db654e1370bebcb7a2a63e7d43eb5a6.jpeg) It appears to me there is some additional setting or something, but I have no idea where to look into. Any suggestion on what I could be doing wrong is appreciated or what to look into. ---
**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:** [June 7, 2025, 10:04am UTC](https://community.glideapps.com/t/lookup-column-not-showing-values-in-collection-table/82302/2 "2025-06-07T10:04:21Z")
> [@Rob\_Cap](#): > > ‘Users’, with a lot of columns. The relevant ones are Band Name and School Name There may be other relevant columns. In particular, check the Email column, if there is one. If that (or any other column) has row owners applied, that would almost certainly be the source of your problem. ---
**Author:** ![Rob\_Cap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rob_cap/32/87029_2.png) [@Rob\_Cap](https://community.glideapps.com/u/Rob_Cap)\ **Post date:** [June 7, 2025, 10:40am UTC](https://community.glideapps.com/t/lookup-column-not-showing-values-in-collection-table/82302/3 "2025-06-07T10:40:04Z")
oh … let me look into it. Thanks ---
**Author:** ![Rob\_Cap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rob_cap/32/87029_2.png) [@Rob\_Cap](https://community.glideapps.com/u/Rob_Cap)\ **Post date:** [June 7, 2025, 10:42am UTC](https://community.glideapps.com/t/lookup-column-not-showing-values-in-collection-table/82302/4 "2025-06-07T10:42:27Z")
Bingo. That was the issue. ---
**Author:** ![Rob\_Cap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rob_cap/32/87029_2.png) [@Rob\_Cap](https://community.glideapps.com/u/Rob_Cap)\ **Post date:** [June 9, 2025, 11:16am UTC](https://community.glideapps.com/t/lookup-column-not-showing-values-in-collection-table/82302/5 "2025-06-09T11:16:51Z")
I removed the row owner and data displays correctly. However, it caused other issues in other pages (e.g. the set lists are not band specific anymore) Is there a workaround? Thanks ---
**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:** [June 9, 2025, 11:33am UTC](https://community.glideapps.com/t/lookup-column-not-showing-values-in-collection-table/82302/6 "2025-06-09T11:33:16Z")
If data security is not important, then you can just apply appropriate filters to your collections. Otherwise, you would need to look into using roles as row owners. ---
**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 16, 2025, 11:33am UTC](https://community.glideapps.com/t/lookup-column-not-showing-values-in-collection-table/82302/7 "2025-06-16T11:33:57Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.