>>>>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.