how to avoid interrupting sequence number for unique id in a table

[Fritz Theiss]

hi,

let us assume i have a table with two columns, named u_id and s_subject.
further assumed is: i may have three datasets inside (three rows filled),
with id 1, 2 and 3 as u_id and the related s_subject.

i now delete dataset with u_id 2. now i do have left as u_ids the numbers 1
and 3 and the related s_subjects.

however i now would like to have u_id of recordset 3 becoming no. 2
automatically when having deleted recordset 2. in general: as soon as i
delete a recordset all u_ids following the one being deleted should be
subtraced by 1. this means: no number is missing in between when deleting a
recordset. please note: u_id still has to provide a unique number.

please provide a step-by-step-guide (if possible) as i am not an
access-expert.

 

[Douglas J. Steele]

What you're asking to do is not simple, and, in fact, is generally
considered to be a bad idea. Why do you feel it's necessary?