Experts: How to disable maximum rows 500 for drop down boxes
I am using multiple drop down boxes that have dynamic entry lists and influence each other. Lets say:
- Product (determined by Division)
- Customer (determined by Division and Product)
Now if my dashboard is start up the drop down box for customer only contains values between A... and K..... Customers that start with the letter L or higher are not shown. After choosing a division Customers starting with A... till P... are shown. After choosing a specific product all relevant Customers are shown.
What happens is that the drop down box looks at the output of the query that is underneed. If this query contains more than 500 rows only the first 500 rows are counted.
I would like to let the drop down box include all rows. How can I do this? For queries that are dragged to the storyboard it is possible to select the maximum rows. For queries that are used in a drop down box this is not possible.
Thanks in advance,