insert into existing table at specific point with autonumber p.k.

[Kevin Campbell]

Hello,

My problem is I have an existing table called customer. The primary key of this table is CustID, an auto-incrementing number with 3 fields, CustName, CustAddress, CustPhone. This table has around 4000 records. I was assigned a new table today that contains only a CustName, CustAddrss, and CustPhone called new_customer with about 2000 records. The new_customer table has no primary key, just those 3 fields. I want to insert the data from the new_customer table into the existing customer table after the last existing record. How do I insert those records into the existing table after the last autonumber position (4083 for CustID in customer table) and auto-increment the CustId for each record. I'm using Access 2003. Some sort of looping structure?

Thank you in advance,
Kevin

 

[trucktime]

Insert

Use an Append Query, the ID will be automatically incremented for the new records in the existing table.