thanks i will give this a try.

thanks for the information Jeff - still looking for how to link. found a stored proc but nothing on how to use it.

I don't have a primary key between systems, but the code and notuniqueid form a key.

Not sure how to create a linked server (so my answer is no i don't...