Questions:

 

1. You have a text column that uses a pop-up list with four values - value 1; value 2; value 3; value 4.  "Entry must be in list" is selected.

 

Now you are in a grid and click the filter drop down arrow at the top of the column and select "Value 1".  Now all items with that value appear in the grid.  But now if you click the filter again, the only value that is available for selection (technically now deselection), other than all, blanks and non-blanks is Value 1.  You have to click on "all" to show all items, before you can then click on the filter again, and see the other four values.

 

Is there a way for the column filter to always display all the values in the pop-up list, so the user can just jump back and forth between values?

 

2. Let's suppose you have a Grid you've created titled "values" for which the data source is "value" (of which there are the four selections mentioned above).  And you've added a column to all 20 grids you have for that value selectiom.  So now you are in the grid you titled "values".  When you filter the value column in the grid to "Blanks", what is that doing?  By which I mean that it seems to bring up a very small number of items.  Yet in theory I'd think that every single item in the database that does not have a value for that field would be a blank, and the list should be huge.  So I'm not sure what other conditions need to be met for something to be a "blanks".

 

I did read the documentation on filters, but didn't see anything that explained this.

 

Thanks