Prev: Invoicing database design
Next: Show employees and others in combo box
From: MTSmith on 4 Nov 2009 21:19
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?
From: Stefan Hoffmann on 5 Nov 2009 03:50
hi,

MTSmith wrote:
> 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?
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 <--
From: Keith Wilby on 5 Nov 2009 04:18
"MTSmith" <MTSmith(a)discussions.microsoft.com> wrote in message
news:B215F60E-35E4-4C7E-AC18-B9543A20F774(a)microsoft.com...
>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?

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.

From: Dorian on 5 Nov 2009 09:42
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".


"MTSmith" wrote:

> 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?
From: Daryl S on 5 Nov 2009 11:35
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.

--
Daryl S


"MTSmith" wrote:

> 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?
 |  Next  |  Last
Pages: 1 2
Prev: Invoicing database design
Next: Show employees and others in combo box