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?
reset it or use a different numbering scheme. Is there an easy way to do
this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J Steele
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.
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.