Chaplain Doug

[Renumbering Related Fields]

Access 2002. I want to renumber a key (field) in one
table that is related to a key in another table. That is,
I want to renumber the key in my primary table and have
the change made in the table to which it is related. How
may I do this? May this be done if the key is the primary
key in the primary table and is autonumber? Thanks for
the help.

 

[Rick B]

If you have the relationship set up with cascading updates, this will happen
automatically.

Rick B


message Access 2002. I want to renumber a key (field) in one
table that is related to a key in another table. That is,
I want to renumber the key in my primary table and have
the change made in the table to which it is related. How
may I do this? May this be done if the key is the primary
key in the primary table and is autonumber? Thanks for
the help.

 

[John Vinson]

Access 2002. I want to renumber a key (field) in one
table that is related to a key in another table. That is,
I want to renumber the key in my primary table and have
the change made in the table to which it is related. How
may I do this? May this be done if the key is the primary
key in the primary table and is autonumber? Thanks for
the help.

Given that there is no way (and generally, no good reason!) to edit an
Autonumber, I'd have to disagree with Rick and say "not at all
easily". An Autonumber has one purpose, and one purpose only: to
provide a unique key. It is not a count; it is not guaranteed to be
sequential; it will, in practice, ALWAYS have gaps. If you aren't
happy with these restrictions, you'll need to use a Long Integer field
as the primary key (with cascade updates set) and maintain it
yourself.

 

[Chaplain Doug]

Just as you dealt with my "spreadsheet" paradigm and set
me on the path to relational design, so have you now dealt
with my "numbers must be in order" neurosis, and given me
a new outlook on the world of autonumber keys. Thanks for
the reminder.