Start at

  • Thread starter Thread starter IfeelSilly
  • Start date Start date
I

IfeelSilly

I am doing an inventory Database and I need my product id number to start at
1 but it has started off at 8. I messed up on it due to wrong info so I
started over and it picked up where I left off.
 
Why do you need the product id number to start at 1? You should never attach
any significance to the value of an Autonumber field. If its value matters
to you, you probably shouldn't be using an Autonumber field.

The only purpose of an Autonumber field is to provide a (practically
guaranteed) unique value that can be used as a Primary Key. 8, 10, 11, 12
serves that purpose just as well as 1, 2, 3, 4 does.
 
Empty your table then do a compact and repair. It should reset the seed.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top