>>>>>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
>
>Of all the suggestions I received, that of Mr. Basoz looked the simplest, so I used that one. It worked great, except that I had to enter the update information by hand in each new copy. Thanks, everybody.

But there is a missing point in my answer.
If you have a complex view that can't be handled by the view designer it won't work.
You could use gendbc than. If your dbc is large, gendbc can't handle it so you might need
to open dbc by use and than copy the related record via *scatter-gather* over a dummy view
in the second dbc.
Cetin Basoz