Append Querry, Key Violations, AutoNumber?

[Guest]

I have a table that has 129 records..

...trying to append (via Querry) 6 fields from tbl1 into a table with 30
fields..tbl2. The format for tbl1 6 fields were copied from and have the
same data layout as the 30 fields in tbl2.

Tbl2 with the 30 fields has an autonumber field. I deleted the key from
this autonumber field, and the relationship that was dependent upon that key
autonumber field. Autonumber is indexed..no duplicates.. I am NOT appending
any data into the autonumber field. I assumed the autonumber would simply
add a incremented number to the new records. I would apparantly be wrong.

Tbl1 and it's 6 fields does NOT have any field that is appending into the
autonumber field in tbl2. Tbl1 and the 6 fields is entirely 6 TEXT fields..
name,address,city,state,zip,phone.

I still get key violations. This is way too simple... but I'm stumped.

I cannot cut/paste from tbl1 into tbl2 because they do not have the same
layout.. I need to run a query.

????????

 

[Guest]

I cannot cut/paste from tbl1 into tbl2 because they do not have the same
layout.
You can copy paste if you run select queries on the six fields so they are
the same.