G
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..
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.
G
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
the record number to that associated record changes..
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
each particular record? When new records are added generallyIs there any way you can have a record number related to
the record number to that associated record changes..
G
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
the record number to that associated record changes.
----- 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
each particular record? When new records are added generallIs there any way you can have a record number related t
the record number to that associated record changes.
G
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
apply it to the existing records. SO that the numbering will
start from the last record? e.g. from record 1089..
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
already. Is there a way to assign a new auto ID field andThanks Gary. Yes, I do have a field with a primary key
apply it to the existing records. SO that the numbering will
start from the last record? e.g. from record 1089..