create a sequential number field

[Jean]

I need to create multiple tables for physical inventory
with part info and a sequentially numbered field starting
with 1 for each file to be used for count tag#. I created
the tables with tag# being an autonumber field, but when I
run the append query to add the records to each file, I
get unexpected results. The tag# in each file is always
sequentially number, but never starts with 1 and I can see
no rhyme or reason to how it's getting the beginning
number. Thankss for any help with this problem.

 

[HSalim]

are you saying you have one table for each inventory item ?
That is bad database design -

 

[Jean]

No, of course not!! I have hundreds or thousands of items
per table, there is a table per inventory location, as
required by our manufacturing software. Any help with the
original question?