# Bug in Select with filters from another collection? **URL:** \ **Category:** Get Help\ **Created:** [October 4, 2020, 4:28pm UTC](https://forum.adalo.com/t/bug-in-select-with-filters-from-another-collection/4601 "2020-10-04T16:28:27Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![sebastas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sebastas/32/3447_2.png) [@sebastas](https://forum.adalo.com/u/sebastas)\ **Post date:** [October 4, 2020, 4:28pm UTC](https://forum.adalo.com/t/bug-in-select-with-filters-from-another-collection/4601/1 "2020-10-04T16:28:27Z")
I have a collection with numbers from 1 to 10 and then I have collection with MaxCapacity. The goal is to show all numbers in collection 1 in a select field that are below or equal the MaxCapacity. In the filter I use: SElect numbers WHERE people “less or equal then” MAX(maxcapacity). ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7cd41527447306c4121099d6075016e1a1486b0d.png) I applied a select with that condition but it does not return anything at all. Thank you. ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [October 5, 2020, 10:37am UTC](https://forum.adalo.com/t/bug-in-select-with-filters-from-another-collection/4601/2 "2020-10-05T10:37:22Z")
Have to set a relationship between the collection of numbers and the MaxCapacity? ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [October 15, 2020, 10:37am UTC](https://forum.adalo.com/t/bug-in-select-with-filters-from-another-collection/4601/3 "2020-10-15T10:37:24Z")
Closed on October 15, 2020, 10:37am UTC This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.