Hello-You can make views 'by and' and still store them in your DBC by using the CREATE SQL VIEW command. Check it out in the help. This will solve your problem. Also note that in the Designer, when you click the View SQL option, it does not show you the REAL SQL for the view. For that, you need to use DBGETPROP. I and many others have created nice tools to be able to view and change the various properties. The VFP View Designer is nice, but limited and show some erroneuos info.

Hope this gets you going.

Dave

ps- in answer to your specific question ( in case you do not like my above answer ), you should probably create the views in the load event of the form.