# Big Tables - Lookup 100 rows limit 🤯

**URL:** https://community.glideapps.com/t/big-tables-lookup-100-rows-limit/86710
**Category:** Ask for Help
**Created:** [March 20, 2026, 8:14pm UTC](https://community.glideapps.com/t/big-tables-lookup-100-rows-limit/86710 "2026-03-20T20:14:34Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)
#### Post date: [March 20, 2026, 8:14pm UTC](https://community.glideapps.com/t/big-tables-lookup-100-rows-limit/86710/1 "2026-03-20T20:14:34Z")

</div>

Hi

I have a Query from a Glide Table to a Glide Big Table which returns over 100 rows.

All good, but I need to lookup the row IDs from the results - but of course I only get the first 100 - which is no good for me.

Is there a work around?

Andrew

---

<div class="post-metadata">

### Author: ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)
#### Post date: [March 20, 2026, 8:20pm UTC](https://community.glideapps.com/t/big-tables-lookup-100-rows-limit/86710/2 "2026-03-20T20:20:40Z")

</div>

May have answered my own question.

Is it to use a Joined List to do the lookup, then split text if necessary?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 21, 2026, 1:13am UTC](https://community.glideapps.com/t/big-tables-lookup-100-rows-limit/86710/3 "2026-03-21T01:13:24Z")

</div>

Do you mean using Joined List through the query? Or just a joined list of all IDs and then calculate only the relevant IDs somehow?

---

<div class="post-metadata">

### Author: ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)
#### Post date: [March 21, 2026, 7:00am UTC](https://community.glideapps.com/t/big-tables-lookup-100-rows-limit/86710/4 "2026-03-21T07:00:35Z")

</div>

Oh

Use a joined list through the query then split text it.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 23, 2026, 1:02am UTC](https://community.glideapps.com/t/big-tables-lookup-100-rows-limit/86710/5 "2026-03-23T01:02:05Z")

</div>

Is that joined list limited to 100 records?

---

<div class="post-metadata">

### Author: ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)
#### Post date: [March 23, 2026, 5:06pm UTC](https://community.glideapps.com/t/big-tables-lookup-100-rows-limit/86710/6 "2026-03-23T17:06:07Z")

</div>

No - it is currently returning 132 records