I am trying to write a script that duplicates records. The job number is the file id and needs to be unique. This is also an attached sql table. Right now I am coping all the fields to variables, creating a new record with a new job number than coping all the data back in from the variables. Is there an easier/more efficient way to do this? Copy to a temporary table or something. If I every need to add a new field the script needs to be changed also.