Possibly Simple, Possibly Dumb Question.

I've developed a database for a small company but've now encountered a few problems. Initially, I was asked to create a table of customers and a table for business to business trade. However, I was then asked to merge the two tables together.

This led to a problem. The primary key was set to adhere with the already existing ID numbers of customers which were created by the company director years ago before the leap in to technology. For example, their first customer had an ID number of 1 outside of the database, and thus in the database the first customer would have an ID number of 1. This is simple, and could be achieved with an autonumber.

Outside of the database, ID numbers were created chronologically, so the first business to business trade did not have an ID number of 1, more something like 321. As I said a while back, the two tables had to be merged, and this left me with every customer in the first ~1000 and then all the B2B trade lumped on at the end. The question I'm thus asking is there anyway I can reorder the records selectively to retain their original ID number? It'd save the director a bunch of time.

Thanks in advance, David.