# Relation rows limit **URL:** \ **Category:** Ask for Help\ **Created:** [June 16, 2026, 4:46pm UTC](https://community.glideapps.com/t/relation-rows-limit/87330 "2026-06-16T16:46:19Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![ANT91](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ant91/32/83354_2.png) [@ANT91](https://community.glideapps.com/u/ANT91)\ **Post date:** [June 16, 2026, 4:46pm UTC](https://community.glideapps.com/t/relation-rows-limit/87330/1 "2026-06-16T16:46:20Z")
Hello, I’d like to know if there’s a row limit for “Relation”. To give you some context, I’m currently cataloging my entire inventory, and there are over 300 rows. I’ve created a “Relation” between two tables to retrieve this inventory so my technicians can enter the parts they used on their work orders. However, when I create the “Relation”, the word “Query” appears on each row, and I don’t know what it means. I also can’t seem to find my “Relation” in my layout component… I know there are no errors in my “Relation” because the system previously worked with an older inventory table (with fewer rows than the current one) that I created, but it hasn’t worked since I imported my new inventory. Thank you very much in advance for your help. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [June 16, 2026, 5:23pm UTC](https://community.glideapps.com/t/relation-rows-limit/87330/2 "2026-06-16T17:23:10Z")
Are you working on a Glide big table ou regular table? You can see this by looking at the icon left of the name of the table in the Data Editor: ![Screenshot 2026-06-16 at 19.21.41](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/4167a85277559c2a147c85c1b619a17070c3ff66.png) ---
**Author:** ![ANT91](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ant91/32/83354_2.png) [@ANT91](https://community.glideapps.com/u/ANT91)\ **Post date:** [June 16, 2026, 5:25pm UTC](https://community.glideapps.com/t/relation-rows-limit/87330/3 "2026-06-16T17:25:16Z")
Mon stock est dans une grande table Glide et celle des interventions dans une table standard ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [June 16, 2026, 5:34pm UTC](https://community.glideapps.com/t/relation-rows-limit/87330/4 "2026-06-16T17:34:16Z")
Je ne suis pas fan des grandes tables. Si tu es certain que les entrées ont vocation à croître énormément, alors certes il te faut une grande table. Mais si tu n’es pas sûr, étudie bien la question. Les grandes tables ont des avantages mais aussi des limitations : [Glide Big Tables](https://www.glideapps.com/docs/essentials/data-sources/big-tables) > **Limitations of Big Tables** > > There are some features in Glide that aren’t compatible with a Big Table. These unavailable features are: > > - **Single Value columns** : Cannot target a Big Table directly but work via [Multiple Relations](https://www.glideapps.com/docs/automation/computed-columns/relations#building-multiple-relations) or [Queries](https://www.glideapps.com/docs/automation/computed-columns/query-column). Only Single Value → First is supported. > > - [Lookups](https://www.glideapps.com/docs/lookup-column) into Big Tables (eg. Lookups via Multiple Relations or Lookups that target an entire Big Table column) are supported in Multiple Relations and Queries but limited to 100 matching rows. > > - [Rollups](https://www.glideapps.com/docs/rollup-column) and [Joined Lists](https://www.glideapps.com/docs/automation/computed-columns/joined-list): Work with most computed columns but are limited to 100 matching rows. > > - **Delete Rows action:** Cannot be applied through a multi-relation in Big Tables. > > - The [User Profile](https://www.glideapps.com/docs/user-profiles) data source cannot be a Big Table. > > - Aggregations in general are limited to 100 matching rows. ---
**Author:** ![ANT91](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ant91/32/83354_2.png) [@ANT91](https://community.glideapps.com/u/ANT91)\ **Post date:** [June 16, 2026, 5:40pm UTC](https://community.glideapps.com/t/relation-rows-limit/87330/5 "2026-06-16T17:40:42Z")
D’accord merci, c’est bien ce qui me semblait il y a une limite dans la recherche à partir d’un composant “Choice” par exemple, il ne peut pas me faire choisir plus de 100 ligne de produit de mon stock… Malheureusement, j’ai essayé d’importé mon tableau excel à partir d’une table normale et ce dernier ne fonctionnait pas. C’est donc pour cela que j’avais opté pour une grande table. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [June 16, 2026, 6:12pm UTC](https://community.glideapps.com/t/relation-rows-limit/87330/6 "2026-06-16T18:12:54Z")
Tu peux importer un fichier CSV bien propre ? ---
**Author:** ![ANT91](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ant91/32/83354_2.png) [@ANT91](https://community.glideapps.com/u/ANT91)\ **Post date:** [June 16, 2026, 6:22pm UTC](https://community.glideapps.com/t/relation-rows-limit/87330/7 "2026-06-16T18:22:57Z")
Je réessayerais demain car le tableau Excel est sur le pc de mon entreprise mais j’avais bel et bien importer en CSV et cela n’avait pas fonctionné, ça me disait que le fichier était trop volumineux..