I have several Access 2000 databases which are in the same structure. Now I need to merge them into one database and upgrade to sql server 7.0. Since there are many parent/child relation connected by some autonumber primary key field, for example, orders.OrderID is a autonumber field and is the primary key of table orders, orderdetail.orderID is a foreign key point to orders table, so the same table come from different database will possiblly have the same orderID, but they are different order. I need to change the orderID in the orders table as well as in the orderdetail table. Is there a good way to got it?<BR> Wish your help! TIA.