Thanks for the response. My posting wasn't as clear as it could be as I was actually more interested in the last question, namely if there is a way to use views created at run time with MM. The field swap I had figured out, but in the view designer, there's a limit to how complicated you can make the where statement, so I was looking for other options.
Thanks,
June
>Hi June,
>
>>If I've got a parameterized view where sometimes I want to use field1 as the comparison for the parameter, and sometimes I want to use field2 (with a different value for the parameter), how do I do this with MM? Do I have to create two views, identical except for the filter tab, or is there some other way? Is there a way to use views created at run time with MM?
>>
>
>I don't use MM, but can you create one view with filters on both fields? Then, set one of the filter variables to a wildcard (or empty string) when you are not using it. In other words:
>
>lcParameter1 = "FilterValue"
>lcParameter2 = ""
>Select * from MyTable where Field1 = ?lcParameter1 and Field2 = ?lcParameter2
>
>Swap the values for the variables when you want to filter on Field2.