Hi all,
I want to copy same fields in the table but getting problem in copying records .I got like 10 tables filled with several records. I want from each table all the records added to these same tables with just 1 field changed (same field in all tables: company_ID). I tried this first in code by walking through all tables and make a temp table then changed this field and then make an append query, but of course this gave conflicts, since all tables have an autonumber indexed primary key field. So im not sure how to solve this problem.

Please give me some solution.
Thanks