>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?
The safest way I've found is to run Gendbc, find and copy all the view's section code in the output to a separate little program, and run it on the new database...save the view creation prg for later use. This is also the first step in creating views that the view designer cannot handle.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.