Duping or Importing

[Peter Kilcoyne]

Hi Folks:

My question is what's the best method to dupe records? I have two  
databases, one is the "main" database where using a portal the user  
creates and view "parts" of the main job that will live in the second  
database. But since a majority of the work we do has been done last  
year and only needs minor updates, I want to duplicate the older  
"Parts" into the new "Main" with a new job number which is auto  
generated via a script when a new job is created.

The idea is the user would search the records for the job they want  
to dupe and via a script the would be able to import/dupe all of the  
records associated with that job into the new "Main" job with the  
updated job numbers. Then they can go about making the minor  
informational changes manually

Any ideas?
TIA:
Peter