Problem with append query and autonumber field

[PepeGallo]

Hi everybody,

I am appending the information I have in one table to another. The first table's name is Videos and it only has 5 records. When I append the information from the other table which has some of the fields of the Videos table (but doesn't have a primary key), the new records in the Videos table have as primary key value (the autonumber field) values that start from 44699657. Why is this happening?

 

[Ziggy1]

make sure the auto number is set to sequential and not Random

 

[PepeGallo]

Yes, it is already set in increment, not in random, and doesn't work