>>Is it possible to make view as follows:?
>>SELECT * FROM table1 ;
>>UNION ;
>>SELECT * FROM table2
>>
>>Where table1 and table2 has identical structure.
>>
>>Giedrius
>Hi Giedrius,
>Yes you could do it just by adding "create sql view myViewName as .." in front. In view designer no way to do it AFAIK. I'm not sure of this but IMHO that would be practically a nonUpdatable view and hence not much different from an editable cursor (except that you could set some properites directly in DBC where for an editable cursor you should redo it on the fly).
>Cetin

Well not really - the way the updateable views are implemented in VFP you can do even worse things like creating a view on one table and updating a completely different one

Arnon