Error - due to key violation ???

[SpookiePower]

I have these two tables, in two different mdb files.

http://www.anothermasterpiece.com/help/access2.jpg

I now want to transfer the data from the one table,
to the other. But I get this error -

http://www.anothermasterpiece.com/help/access.jpg

I have no idea how to fix this error. Can someone help me ?

 

[Douglas J. Steele]

Since fId is an AutoNumber, odds are that the same values exist in both
tables. You can't add fId 123 from taSlukkere1 to taSlukkere if fId 123
already exists in tbSlukkere.

When bringing in the data from the second table, bring everything EXCEPT
fId. New values of fId will be assigned for all of the new rows.

 

[SpookiePower]

Since fId is an AutoNumber, odds are that the same values exist in both
tables. You can't add fId 123 from taSlukkere1 to taSlukkere if fId 123
already exists in tbSlukkere.

I can see that....now

Thanks a lot

When bringing in the data from the second table, bring everything EXCEPT
fId. New values of fId will be assigned for all of the new rows.

I will try that. Thanks.