# Relationship returns no value **URL:** \ **Category:** Ask for Help\ **Created:** [September 15, 2022, 2:15pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369 "2022-09-15T14:15:47Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![MattJP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattjp/32/47532_2.png) [@MattJP](https://community.glideapps.com/u/MattJP)\ **Post date:** [September 15, 2022, 2:15pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/1 "2022-09-15T14:15:47Z")
I have created a 1:1 relation using row id. I get some related records but most are blank and when I filter the Sheet data with a row id key value that returns no related data in the relation it is there in the Sheet data source. In order to rule out some effect of row id I also created a second relation using a separate unique key. Same result. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d25a00e2b9dc29b3b5c1733b3c375a3bea5d2295.png) Note the first row id key value shows no related record However, that key value has a record in the related table (see inset in red frame). I am a free account newbie so I’m confident I am doing something dumb but: - I have searched pretty thoroughly. - I am not using row ownership or any visibility logic. - I have checked the limits on the free account and can find no mention of relations ---
**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 15, 2022, 2:33pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/2 "2022-09-15T14:33:04Z")
Can you provide some additional screen shots please: - One that shows how your relation column is configured - One that shows your first table, including the column headings - One that shows your second table, including the column headings and with at least one non-matching row visible Basically, I want to first see that your relation is correctly configured, and then see enough that it’s clear there are non-matching rows where there should be. ---
**Author:** ![MattJP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattjp/32/47532_2.png) [@MattJP](https://community.glideapps.com/u/MattJP)\ **Post date:** [September 15, 2022, 3:20pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/3 "2022-09-15T15:20:18Z")
Thanks @Darren_Murphy , > - One that shows how your relation column is configured ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c41d7bec28c73123c79a72b829c99361990e7dab.png) > - One that shows your first table, including the column headings ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/ee4f107395b9e7c080cf6ce48d7f081566b38866.jpeg) > - One that shows your second table, including the column headings and with at least one non-matching row visible > ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b607b17954a07358c3061e2ad82c9340245f2e5.png) I struggled with this because the data editor only shows 25 rows of the related table, none of which match on the screen shot I made of the first table. Glide allocated row ids to all rows so I think it is not truncating the data. Perhaps we could solve this wrinkle first? ---
**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 15, 2022, 3:48pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/4 "2022-09-15T15:48:43Z")
How many rows in total in your Aphorisms table? Of the 3 shown… ![Screen Shot 2022-09-15 at 11.45.48 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1f55375adade673877e2170652365ecae8c020c1.png) I don’t see any of those RowID’s present in the Aphorism column in your first table. So based on what you’ve shown, I can’t see anything wrong? ---
**Author:** ![MattJP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattjp/32/47532_2.png) [@MattJP](https://community.glideapps.com/u/MattJP)\ **Post date:** [September 15, 2022, 4:11pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/5 "2022-09-15T16:11:16Z")
499 all with row ids generated by Glide. I can’t find any obvious reason why it would show on 25 rows in the data editor. The 25th and 26th row both unremarkable. However, it does explain the other problem. The only relations that returned data were in the first 25 rows of the related table. Clearly glide thinks the data stops at row 25. Is there a table config somewhere that shows the extent of the table Glide sees? ---
**Author:** ![MattJP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattjp/32/47532_2.png) [@MattJP](https://community.glideapps.com/u/MattJP)\ **Post date:** [September 15, 2022, 4:15pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/6 "2022-09-15T16:15:20Z")
I’ve tried deleting a few rows either side of 25 and I still get 25 rows with the deleted data missing as expected. ---
**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 15, 2022, 4:18pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/7 "2022-09-15T16:18:07Z")
> [@MattJP](#): > > Is there a table config somewhere that shows the extent of the table Glide sees? No, but it is limited by the type of plan you are on. The Free Plan, for example, is limited to 500 rows. I still haven’t actually seen anything in your screen shots that shows rows not being matched that should be, so I’m not 100% convinced that it isn’t working as expected. Just a couple more questions: - How is the Aphorism column in your first table populated? - Are Glide Tables your only data source, or are you also using another external data source? (Actually, from your very first screen shot it looks like you have a Google Spreadsheet connected?) ---
**Author:** ![MattJP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattjp/32/47532_2.png) [@MattJP](https://community.glideapps.com/u/MattJP)\ **Post date:** [September 15, 2022, 4:29pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/8 "2022-09-15T16:29:14Z")
> [@Darren\_Murphy](#): > > - How is the Aphorism column in your first table populated? Commitments table and Aphorisms table were originally related with a foreign key in Commitments. I understood that I’d be better off using row id if I wanted unique keys generated by Glide so I created a row id column for the Aphorism table. I then did a vlookup in the Google Sheet to map the original FK to the row id. I pasted the values I got into the Commitments.Aphorishsm column. I did another Vlookup to test that I had the right mapping (subsequently deleted). When I realised I had a problem I used the original FK for a second relation column that demonstrated the same problem. I am now convinced that the relations are returning nothing because Glide can’t see beyond 25 rows in the Aphorism column. I checked and all the relations that worked correctly are in those 25 rows. > [@Darren\_Murphy](#): > > - Are Glide Tables your only data source, or are you also using another external data source? (Actually, from your very first screen shot it looks like you have a Google Spreadsheet connected?) Google Sheet is the main source of data but there is one Glide table generated by Glide, Users. I understand the row limitations for free accounts but that’s per table, yes It’s the end of my workday here in the UK so I’m going to think some more and hope inspiration strikes me. ---
**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 15, 2022, 4:32pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/9 "2022-09-15T16:32:50Z")
> [@MattJP](#): > > I understand the row limitations for free accounts but that’s per table, yes No, it’s per Project. But if you have exceeded the row limit, you should see a warning about that. ---
**Author:** ![MattJP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattjp/32/47532_2.png) [@MattJP](https://community.glideapps.com/u/MattJP)\ **Post date:** [September 15, 2022, 6:12pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/10 "2022-09-15T18:12:21Z")
Thanks. I’ll have a closer look but that’ll be it, I’m guessing. Thanks again. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 15, 2022, 8:39pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/11 "2022-09-15T20:39:27Z")
If you have more than 500 rows in your app, and you’re on our free tier, we don’t load more than 500 rows, so your relations will not show. ---
**Author:** ![MattJP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattjp/32/47532_2.png) [@MattJP](https://community.glideapps.com/u/MattJP)\ **Post date:** [September 15, 2022, 8:41pm UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/12 "2022-09-15T20:41:36Z")
Thanks to @Darren_Murphy for his help and advice and @david for his confirmation. I deleted a bunch of rows to get under the limit and confirmed this was the problem but I saw no obvious warning or error. My fault for misreading the conditions of the free tier. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 16, 2022, 1:14am UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/13 "2022-09-16T01:14:53Z")
Don’t worry – soon when you are over 500 rows, we will make it **very** obvious 😉 ---
**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:** [September 17, 2022, 1:15am UTC](https://community.glideapps.com/t/relationship-returns-no-value/49369/14 "2022-09-17T01:15:29Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.