Bug in Select with filters from another collection?

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

I applied a select with that condition but it does not return anything at all. Thank you.

Have to set a relationship between the collection of numbers and the MaxCapacity?

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