T
titlepusher
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.
????????
...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.
????????