June,

If you are using VFP 8 the built in view designer does a pretty good job since it includes the Priority option. We use ViewEditor in VFP 6 (which now only comes in a Professional version from http://www.whitelightcomputing.com) and have used eView (available in the downloads area) in the past to edit our more complicated views.

Yes, you can use unions in your SQL if you don't use the view designer. Just use the CREATE SQL VIEW command to create it and DBSETPROP to set the appropriate properties. You should check out ViewEditor if you are going to be doing a lot of view work.

-Dan


>If the where clause is simple enough, that will work, but there is a limit to how complicated it can be and still be able to spcify it in the view designer.
>
>If it gets to the point that the view designer can't be used, I guess the GenDBC method is used to create the views? If I go that route, can I use Unions in my SQL?
>
>Thanks,
>
>June
>
>>June,
>>
>>One way would be to use a logical parameter that indicates which comparison you want to use (.t. = field1, .f. = field2) and code your WHERE clause appropriately.
>>
>>HTH
>>
>>-Dan
>>
>>>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?
>>>
>>>Thanks,
>>>
>>>June