I got some data into a table (15K records) that I need to add to a table from which primary key is an autonumber.

Assuming the autonumber field is F0 onto the table T1 and my data are currently into a table T2, I have tried insert into T1(F1,F2,F3) select F1,F2,F3 from T2. But bogus it start complaining after the first inserted row. Apprently the autonumber do not get auto value...

How to address this issue?

Thank for your future help