# Collection not functioning using values from screen

**URL:** <https://community.glideapps.com/t/collection-not-functioning-using-values-from-screen/74110>\
**Category:** Ask for Help\
**Created:** [June 13, 2024, 2:47pm UTC](https://community.glideapps.com/t/collection-not-functioning-using-values-from-screen/74110 "2024-06-13T14:47:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\
**Post date:** [June 13, 2024, 2:47pm UTC](https://community.glideapps.com/t/collection-not-functioning-using-values-from-screen/74110/1 "2024-06-13T14:47:56Z")

</div>

I have a books table and a chapters table. When a chapter row is created, I include the rowID of the book so that all chapters can link to the proper book. Problem is that when I filter the chapter collection based on matching the book rowID from the chapters table to the screen value of the rowID from books, it does not work, When I hard code the books rowID into the filter table to match it to the rowID in the chapters table, the filter works. Any ideas are appreciated.

Thank you

---

<div class="post-metadata">

**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:** [June 13, 2024, 2:58pm UTC](https://community.glideapps.com/t/collection-not-functioning-using-values-from-screen/74110/2 "2024-06-13T14:58:04Z")

</div>

Based on your description, it seems like it should work, but it’s hard to say without screenshots showing how you have everything configured.

However, for something like this, I would personally create a relation in the book table linking the book to the chapters. Then, assuming you are on the book detail screen, change the source of the collection to use the relation. Then you won’t need a filter.

---

<div class="post-metadata">

**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\
**Post date:** [June 13, 2024, 3:20pm UTC](https://community.glideapps.com/t/collection-not-functioning-using-values-from-screen/74110/3 "2024-06-13T15:20:20Z")

</div>

The relation did the trick. Thank you

---

<div class="post-metadata">

**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 20, 2024, 3:20pm UTC](https://community.glideapps.com/t/collection-not-functioning-using-values-from-screen/74110/4 "2024-06-20T15:20:56Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.