Create table from another but include ID

[sumdumgai]

Hello. I want to create Table1 from a subset of the records in Table2, but I want to include the 'ID' auto-number that the Table2 records have. I can do the create table okay, but the 'ID's that are in Table1 are newly generated ones, not the existtng 'ID' numbers in Table2. I get the existing 'ID's when I do a 'Select', but inserting into another table gives me new 'ID's. Hope that makes sense. Any help would be appreciated.

Thanks.

 

[NauticalGent]

Change the Field in Table1 from AutoNumber to Long Integer.