create a sequential number field

  • Thread starter Thread starter Jean
  • Start date Start date
J

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.
 
are you saying you have one table for each inventory item ?
That is bad database design -
 
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?
 
Back
Top