I have a bit of a problem here. I am trying to make an Access database for
my business, and this requires all the people to be numbered like this:

1,2,3,4,5,6,7,8,9,10

The problem is when I have to add someone. I might have to fit the new
person in between two others:

1,2,3,4,(new person),5,6,7,8,9,10

so now the new person becomes 5, 5 becomes 6, 6 becomes 7 etc. Currently I
am stuck with manually doing the renumbering. Does anyone know of a way of
automatically doing this?