Prev: Invoicing database design
Next: Show employees and others in combo box
From: MTSmith on 6 Nov 2009 18:41
I may have done that. I'll check that out. Thanks for your input!
Terry

"Daryl S" wrote:

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