Joe;

There are two types of views available to VFP - Local and Remote. Do a bit of research and ask questions. There is a View Designer in VFP, which can get you off to a quick start. However, the best way to create views is with a prg. There is a prg called gendbc.prg that will allow you to do this. You can run gendbc against an existing DBC and it will produce the code for the creation of the DBC, Tables, CDX and all views.

By understanding the functionality of gendbc, you can write your own utility to do the above. Anything is simple when you do it enough times. If you need more information just ask.

Tom