Autonumbers

[tomc]

I am in the process of combining several different databases but need a unique number to identify each record for label printing, etc. It seems that when I append a table to an existing one the autonumber field repeats itself. In other words there are two records with an autonumber field value of 478. How can I append records but still allow each record to have a unique identifier?

Thanks,

Tom

 

[TessB]

Have you set your AutoNum field to Duplicates no? (View the table in Design view and look at the AutoNum field's properties at the bottom)
It won't allow duplicate numbers if you have.

Also, if you are combining data and want to preserve the original number for searching, you could add a field, "Old Auto Num".
Do an append query and set the AutoNum field to append to "Old Auto Num".

If you do not need to preserve the old number, just don't include the AutoNum field in the append query and the AutoNum field on the first table will generate a new AutoNum for that record.

 

[tomc]

Thanks, I'll give that a try.