Hi,
Some questions regarding the filter component:
Is there a limit to the number of options you can have within a filter?
Can you select more than one option within a filter?
Can the filter options be dynamically controlled and displayed based on the selections in a prior filter?
Thanks!
jwoj (BOB member since 2008-08-03)
You can use filters on a large number of values. I think the upper limit is around 500 or so. There is definately a point where the tool no longer holds values. But hey, over 200 is ridiculous anyway. If you really really want to know…Make a set of numbered values in Excel from 1-10,000 and bind the filter component or the combo box component to the whole list. Preview it and see how high it goes.
Right now, you can use the List Builder for multi-select options from one list. That is really all there is for multi select.
The Filter component can sort/present unique values from multiple levels of a filter dataset. In other words…Dynamic cascade based on selections. Read the help file on the filter component.
Based on those limitations, here is what many people do…
Dont use any of those tools above. Use combo boxes at divide your top grain into 3 or more parts. Here is an example.
[Country]
combo1 (list of countries A - L)
combo2 (list of countries M- P)
combo3 (list of countries Q - Z)
Each combo box above runs a tiny query when clicked. That query will return [States] in the [Country]. In my example, a user can pick up to 3.
Make 3 more combo boxes.
[State]
combo4 (fed from combo1)
combo5 (fed from combo2)
combo6 ( fed from combo3)
Upon clicking 4,5,6 another tiny query would run returning figures for that [State].
Each combo box has a Null choice as well…in case the end users didnt want to use them.
Cairmor 
(BOB member since 2008-06-05)
Thanks!
jwoj (BOB member since 2008-08-03)