Pete You can have an prg that creates all of your views using the CREATE SQL VIEW command check the help for more info.

>Hello Cetin & Alexandre,
>thank you both for your help, Cetin ( esp ) if you don't use the VFP designers ( I create most of my classes in code! ), how do you create and maintain views ( local or remote )?
>
>thanks again
>
>Pete