Primary Key - Auto Number

  • Thread starter Thread starter CD
  • Start date Start date
C

CD

My Primary key auto numbers my form. Sometimes it's off, and I want to
reset it or use a different numbering scheme. Is there an easy way to do
this?
 
What do you mean by "off"? Are you referring to the fact that the Autonumber
id may be 24, but the form is saying record 23?

Don't expect the value of Autonumber fields to mean anything. Autonumbers
exist for one purpose: to provide a (practically guaranteed) unique value
that can be used as a primary key. Gaps in the Autonumber values are
practically guaranteed, but so what: 1, 2, 5, 6 provides unique values just
as well as 1, 2, 3, 4. Seldom, if ever, should the value of the Autonumber
field be shown to the user. Also, be aware that should you ever need to
Replicate your database, the Autonumber field will be changed from
sequential to random.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access problem 0
Force Autonumber to generate 0
Auto-populate a form 4
auto numbers that aren't primary key 2
Why do my forms not open in order of primary key? 1
Reset Auto number 4
Primary Keys 2
Access record with ID 3

Back
Top