views:

87

answers:

1

Is there a way to add more than one filter on a column programmatically?

Tables("TYPE").AddFilter("Code", "<>", "OP") --  Works until then next line.
Tables("TYPE").AddFilter("Code", "<>", "MP") --  The first filter is removed.

.... I'm not cool enough to add a SatelliteForms tag.

Here is a link to the SatelliteForms.

+1  A: 

Let me put out the disclaimer that I have no experience with SatelliteForms. However, I did comb through the SF_MobileAppGuide and based on the how the AddFilter, RemoveFilter and RemoveAllFilters methods are called, it appears that you can only have one filter per column.

This explains why when you add the second line, it merely replaces your filter instead of adding it.

ichiban
I have found that AppGuide to be incomplete / inaccurate more then a few times. Here is the other fun part you can add a button to a from then add multiple filters on one column. You can then execute the button's action in code. But when you have 4! possible combinations things get messy fast.
NitroxDM