Appending a table with an autonumber field

[jflash]

I have a tbl in which I store manually input chgs for a particular supplier.
This table is on the many side of a one-to-many relationship. The table has
a PK of date of chg, who chgd it, what field was changed, and an autonumber
chg no. This is because multiple chgs can be made to one supplier on a given
date.

I'm now trying to take a tbl of chg records from another source and append
them to my chg history tbl. I can't seem to figure out how to get the
autonumber field to populate on the records that are being appended. This is
preventing me from appending the records because of key violations.

I realize this may not be the best solution because I could have used date
and time as part of the key. Problem is my chg hist tble already has almost
1K records with no time assoc with them.

Keep in mind I am not good with VBA at all - just enough to be dangerous.
Any ideas as to how I could get around this problem?

Thanks for any help.

Joanne

 

[Evi]

Is there are reason why you need to append the Autonumber field? Does it
link to another table? For my history table, I just made an Autonumber field
and appended my records without that field. (of course, if your Autonumber
field is the foreign key in another table then this won't work.)
Evi