>>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.
I'm curious. Why do you want this view? It seems unusual to make something updateable with a UNION SELECT. I know that many UNION queries will not be updateable, but I don't know the rules there.