Creating a new database can you assign auto #'s to start with 100

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

Guest

In creating a new database, I want the auto numbers to start with 100 & not
1,2,3 & so on. Is there a way to do that. We have several warehouses & I
want the customers in each warehouse to start with a different number.
Warehouse 002 starts 1-99, Warehouse 003 - starts 100-199 & so on.
 
Access Autonumbers are intended for use as a unique row identifier. They
are not guaranteed sequential, and are generally not fit for human
consumption.

If you want to identify which warehouse a customer comes from, use a
[Warehouse] field.

And is there any chance a customer could start in one warehouse any latter
move to another? How will you handle this?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
In creating a new database, I want the auto numbers to start with 100 & not
1,2,3 & so on. Is there a way to do that. We have several warehouses & I
want the customers in each warehouse to start with a different number.
Warehouse 002 starts 1-99, Warehouse 003 - starts 100-199 & so on.
Click to expand...

DON'T do it this way. <g>

Autonumbers have one purpose, and one purpose ONLY: to provide a
guaranteed unique key. That's IT. They're not editable, they aren't
guaranteed to be sequential, and you can't easily dynamically choose
one range or another to insert them.

And worse, you're trying to store two discrete unrelated bits of
information (the identity of the customer, and the identity of the
warehouse) into one field. Not good! Fields should be "atomic", used
for one and only one purpose.

Instead, use a customerID (unrelated to the warehouse), and have a
WarehouseID field in the customer table as a foreign key.

John W. Vinson[MVP]
 
Thank you for your input. Our warehouses are in separate databases & I was
wanting to be able to look at our daily INS & OUTS sheet & tell which
warehouse the items need to be entered into. But if the program don't allow
you to start with different auto numbers then I have to figure out some other
way to identify them. Thank you again.
 
Back
Top