Record vs. addressid

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello, I deleted a lot of records in the db. Now I have 85 records, with
addressid's in the 500's. Is there a way to reorder the addressid's so they
reflect the current records in the db.
Records increment by 1 as well as the addressid, but record # 55 may reflect
addressid # 485.
I am using the current record ID, and have created a field where I enter the
current matched record. No way to automatically capture the record # is
there? I don't see record as a field in the db table.
Bob
 
Unlike some other DBMS, Access doesn't expose a record number. That's
because in relational databases, there's no real concept of "record 1",
"record 2" and so on: records only have a ordinal number once you define
their sort sequence.

It sounds as though your addressid is an Autonumber field, in which case you
should be aware that Autonumbers exist for one purpose only: to provide a
(practically guaranteed) unique value that can be used as a Primary Key.
Rarely (if ever) should the value of the Autonumber field be presented to
the user, and no meaning should ever be assigned to it. In fact, if you ever
replicate your database, all Autonumber fields will be changed from
sequential to random.
 
Back
Top