How do you set the range of allowable numbers for an autonumber fi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2002. I'm working on a database for inventory. There will
be 4 different databases that periodically will be combined. I need an
inventory number to be automatically generated. I was going to assign a
range of numbers for each location, so there would be duplication.
 
Auto number is not intended to create 'useful' numbers. They are simply
behind-the-scene numbers.

Based on what you have said, you would wnat to manually (or through code)
create a stock number as the part was created.

I would not use an auto number for your application.

Rick B
 
Back
Top