First of all thanks for your help, i'm learning alot from this. To answer some questions.

Do you really have a part number 300 character long without any check digits...

Thanks, I kinda got it to work with the import/export wizard. The only problem i'm having now is it fails if I run it again. The table does...

Any good place to start to learn how to do it?

Ya I think that's about what I ended up with. I didn't use a trigger tho just did it with the output command in the insert. So sounds...

no it sticks around permanently. They literally want a copy of the data. The temp tables will go away every time i make a copy cause i'm create...

ya i was using temp tables to store the new primary keys. I did get it to work if I add a field to the table that I can...

It would be an ongoing thing. Its for a CRM kind of project. The customer wants to create multiple versions so they can play with different options.

the new tables are existing tables, technically they are the same tables. I basically copying a record from itself and reinserting it into itself.

SeanLange

could i get an example of what you mean?

ok that doesn't quite work from i need to do, because what i want to capture in the temp table is the new primary key and the old one.

Thanks I will give that a try

The thing is after I insert I need to take that primary key and insert it into a different table because of the relationship as foreign key. All...

Thanks for the help, we are going to look at a different option or see if its truly needed.

Thanks

Thanks that will help.

awesome i will check that out