Copying table with Autonumber field

[Peter Kinsman]

I am copying a database in which a number of tables have Autonumber fields
as their Primary Index, which are used in Bill of Material structures. Some
of the new tables have extra fields.
I was going to use DAO to create the new tables, using lookup tables to link
the Record_ID in the old table to the Record _ID in the new table, but I
find that if I use SQL to create the new table, the values of the Autonumber
fields are preserved.
Does anyone know whether this is a fluke or it should work this way please?

I am using Access 2003

Many thanks

Peter Kinsman

 

[Peter Kinsman]

I have done some further investigation and it would appear that if the new
table has an extra field and the SQL statement is of the form
INSERT INTO...SELECT * FROM
then field mapping is carried out automatically.

Again, does anyone know if this is how it should be please?

Thanks

Peter