# Problem with relation - not showing all items **URL:** \ **Category:** Report a Bug\ **Created:** [March 27, 2020, 4:27am UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933 "2020-03-27T04:27:55Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 27, 2020, 4:27am UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/1 "2020-03-27T04:27:55Z")
My app’s URL: [clgpp.glideapp.io](http://clgpp.glideapp.io) I created a relation, but it’s not showing all the items in the inline list. ![Screen Shot 2020-03-26 at 11.23.58 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/24b14d60a47ee4aca720a83ed93b6084c91726b3.png) ![Screen Shot 2020-03-26 at 11.24.14 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dd2f3f468032ebe3b9a4006c4e63073ebf84720d.png) Is there something going on with Glide? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 27, 2020, 8:49am UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/2 "2020-03-27T08:49:50Z")
Was the relation set to multiple? ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 27, 2020, 10:54pm UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/3 "2020-03-27T22:54:28Z")
Yup, it is ![Screen Shot 2020-03-27 at 5.53.41 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/af9fef9b85ee52f2e704fe242eb88083207bdaab.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 27, 2020, 11:10pm UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/4 "2020-03-27T23:10:47Z")
Is there a filter on the inline list? ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 27, 2020, 11:14pm UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/5 "2020-03-27T23:14:14Z")
nope. I’m super intrigued. I actually re-started again from a blank sheet and app, but it’s not showing all items. I have a couple or relation rows, and with both of them the same issue happens, the inline list only shows the first result. ☹ ![Screen Shot 2020-03-27 at 6.12.58 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/701a6d5c0bf40fb38cc4db45ca1e05ccb8aea285.png) ---
**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 27, 2020, 11:24pm UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/6 "2020-03-27T23:24:22Z")
What does your Menu\_type sheet look like? ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 27, 2020, 11:26pm UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/7 "2020-03-27T23:26:04Z")
Just the menu types. Only one column. ![Screen Shot 2020-03-27 at 6.25.38 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c4f53bb54297dbbf13d649e5b8fda24d6cb7d07d.png) ---
**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 27, 2020, 11:43pm UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/8 "2020-03-27T23:43:19Z")
That’s why your relation is only returning one item. There is only one item to return. Do you actually want to use Menu\_type sheet as your Sales tab in the List Style Layout and have a relation in that sheet to your Sales sheet? Then add an inline list using the relation within the details of each menu item. Also your list was only returning one item because you are in the detail style layout and it’s only displaying the first row from your sales sheet. That first row only had one related item from the menu types sheet, so you only see Bar. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 27, 2020, 11:51pm UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/9 "2020-03-27T23:51:12Z")
Ok, let me get to it. I always get confused with relation columns. Thanks Jeff. ---
**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 27, 2020, 11:55pm UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/10 "2020-03-27T23:55:26Z")
A relation pulls all of related rows from a secondary sheet that matches a value in the primary sheet. Think of a sheet containing offices. When viewing the details for one office, you want to view a list of related employees in that office. The relation would join the office name in the office sheet to the office name in the employee sheet. That way you can add an inline list in the office details of all the employees in that office. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 28, 2020, 12:02am UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/11 "2020-03-28T00:02:27Z")
This maybe is a stupid question… but if in the sales sheet I have rows of sales ( **instead of employees, I have sales** ), and there is a column with the menu\_type ( **which would be the office** ). Then, I have the menu\_type sheet ( **which would be the offices** ). So, I created the relation column in the sales sheet, since I want to generate a view like this one. ![Screen Shot 2020-03-27 at 6.59.11 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/931645fad02deee793181b727c7bc004276505c6.png) I know my logic is wrong since it didn’t work, but can you point to me where I made the _wrong turn_? PS: I know I asked you a bunch of questions about this in another thread, but since I got stuck, I started from a blank canvas again with a different approach. ---
**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 28, 2020, 12:08am UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/12 "2020-03-28T00:08:39Z")
Create the relation in the menu type sheet instead. You are close, but i think you are thinking about it backwards. Make a new tab, or change your sales team to point to the menu type sheet. Like the office employee example, the relation is in the office sheet. We’ll worry about your Totals later. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 28, 2020, 12:21am UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/13 "2020-03-28T00:21:23Z")
Ok, but if the relation is in the menu\_type sheet, then I can’t populate the inline list with the sales numbers, since all the data is in the sales sheet… or can I? ---
**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 28, 2020, 1:02am UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/14 "2020-03-28T01:02:27Z")
That’s where you can use Rollup columns to get the totals. Just create a Rollup column, point it to the relation, then set it to sum the total sales for that menu type. ---
**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:** [February 4, 2024, 2:13pm UTC](https://community.glideapps.com/t/problem-with-relation-not-showing-all-items/5933/15 "2024-02-04T14:13:12Z")