How to dupicate records for similar items.

I have a database with hundreds of records that deal with a particular contract. I want to use these records as the basis for an additional contract, so that we wouldn't have to reenter the same data that already exists for the first contract. If it were all in one table it would be easy to append the same records minus the ID, but there are related tables (one-to-many) that have additional data that also need to to be copied, except with the new ID numbers for the newly appended records as the foreign key. Is there a simple way of doing this with queries, or will I need to write a program to do it?

Thanks