>I have a view of the form:
>
>Define View AView As ;
> Select FieldA,... From Table1 Where &cWhere1 ;
> Union Select FieldA,... From Table2 Where &cWhere2
>
DEFINE VIEW? You mean CREATE VIEW?
Since views defined with the UNION clause are not updatable, is there any reason that you are using a view for this? You would probably be better served just using a query...
Erik Moore
Clientelligence