Greetings!

I am working on a view that CAN have from 0 to 3 filters on it. That is, the WHERE clause could have up to 8 combinations of filters:

1) 1 = A and 2 = B and 3 = C
2) 1 = A and 2 = B
3) 1 = A and 3 = C
4) 2 = B and 3 = C
5) 1 = A
6) 2 = B
7) 3 = C
8) No filter

I must be getting old and suffering from memory failure...reason being, I could almost swear that parameterized views used to return ALL records if the parameter was blank, null or zero (something along those lines??)?? Or was that a Clipper '87 thing? (Now we're going back in time ).

Any ideas on how to write a local view that has three view parameters and may get from 0 to 3 of them populated? (Within the realm of the MM framework of course!).

Thanks!