Appending table autonumber problem

  • Thread starter Thread starter MTSmith
  • Start date Start date
M

MTSmith

I am appending one table to another. The autonumber field in table1 ends at
989. When I append the second table's records, it jumps the number from 989
to 575272. Why does it do that and not just number the next appended record
990?
 
hi,
I am appending one table to another. The autonumber field in table1 ends at
989. When I append the second table's records, it jumps the number from 989
to 575272. Why does it do that and not just number the next appended record
990?
Click to expand...
Autonumber fields are not designed to be sequences with out gaps. They
only ensure that you'll get a unique number. When using a sequential
autonumber, the default, then it guarantees that you'll get a strictliy
increasing number (Caveat: sign flip at 2^32-1).


mfG
--> stefan <--
 
MTSmith said:
I am appending one table to another. The autonumber field in table1 ends
at
989. When I append the second table's records, it jumps the number from
989
to 575272. Why does it do that and not just number the next appended
record
990?
Click to expand...

AutoNaumbers are for internal indexing purposes only and it's value should
be of no consequence to the user. If you want sequential numbering then
you'll have to do that yourself.

Keith.
 
I don't know but autonumbers are guaranteed to be unique, beyond that is not
guaranteed. You cannot assume they will be sequential.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
MT -

In your append query, are you including a field from the second table to go
into the 'autonumber' field in table1? If so, you should not have included
that field in your append query.
 
Back
Top