>>>Is there a way to copy a view from one database to another, assuming the second database has all the necessary tables with all the right fields?
>>
>>VFP ships with a utility called GENDBC. GENDBC will create a script that creates all the objects within you DBC. Run GENDBC and then find the section that contain the view you want to move. Cut the code from the script and run it against your second database.
>>
>>-Mike
>
>GENDBC is, however, size limited. So, if you have say 200 tables with corresponding views in your DBC it isn't likely
>that GENDBC will run correctly.

I haven't tried it, but GENDBCX is supposed to take care of the size problem.

Barbara