How do you turn off the auto numbering?

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

Guest

I am using the inventory template in Access 2000, and the product ID field is
auto number and I want to use our product ID numbers. How would I go about
doing this?
 
Dear SC:

How about adding a new column to the table containing an appropriate
datatype for your product ID. I recommend making a unique index on it. You
can remove the existing autonumber whenever you have the new column set up.

Do you have any existing dependent tables? If you do, you'd need to add the
product ID to that table as well, and build a relationship on that. When
you remove the autonumber, any existing queries, and possible code or forms,
that use the old autonumber will be broken until they are changed.

Making a change like this after deployment will be a real challenge!

Tom Ellison
 
Thankfully this is a brand new database that I am setting up. That should do
the trick and I appreciate your help.
 
Back
Top