>Thanks so much Ed. That really hit the mark. I've been told that a module called eView is much better than View Designer... would you know where it's located in the file archive?
>

In the Files Section under FoxPro in General; it is not a replacement for a visual View Designer; it permits you to create a SQL Select and then manipulate all the properties of the view directly, so that you are not encumbered by the limits of what the View Designer generates for SQL code - but it expects you to be able to create the basic query which becomes the basis of your view; IOW, you still have to know SQL syntax.

>JD