record numbers

[Guest]

Is there any way you can have a record number related to each particular record? When new records are added generally the record number to that associated record changes..

 

[Gary Miller]

If you are referring to the Record Number being the position
in the table, that is irrevelant and not dependable as
records in a table are like popcorn in a bowl. This is why
each record should have a unique ID that is the table's
primary key. This will not change and will be your
dependable 'record number'. It is the most common practice
to setup the ID field as a autonumber and let Access assign
each new record the next highest number.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message

Is there any way you can have a record number related to

each particular record? When new records are added generally
the record number to that associated record changes..

 

[Guest]

Thanks Gary. Yes, I do have a field with a primary key already. Is there a way to assign a new auto ID field and apply it to the existing records. SO that the numbering will start from the last record? e.g. from record 1089.

----- Gary Miller wrote: ----

If you are referring to the Record Number being the positio
in the table, that is irrevelant and not dependable a
records in a table are like popcorn in a bowl. This is wh
each record should have a unique ID that is the table'
primary key. This will not change and will be you
dependable 'record number'. It is the most common practic
to setup the ID field as a autonumber and let Access assig
each new record the next highest number

-

Gary Mille
Gary Miller Computer Service
Sisters, O
_______________________
messag

Is there any way you can have a record number related t

each particular record? When new records are added generall
the record number to that associated record changes.

 

[Gary Miller]

Yes. If you create a new autonumber it should number the
existing records in the order that it finds them in the
table 1 through however many records there are.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message

Thanks Gary. Yes, I do have a field with a primary key

already. Is there a way to assign a new auto ID field and
apply it to the existing records. SO that the numbering will
start from the last record? e.g. from record 1089..