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