>You cannot create view
>with UNION into the VFP view builder
>but you can define the view with code.
>
>
>CREATE SQL VIEW viewUnion as;
>SELECT * FROM dbctry!Table3;
>union all;
>SELECT * FROM dbctry!Table3
>
Thanks Fabio, I will try this approach instead of trying to work with the view builder.
Luc Nadeau
lnadeau@neova.ca"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)