Auto enter number question.
I'm using a solution at the moment to allocate riders to a database for a charity bike ride. Basically i import from an excel document the riders applications. Then I manually allocate them the next riders number. This sounds simple until riders nearer the day drop out. I then remove their rider number and allocate it to the next one to enter.
In simple terms lets say I have allocated numbers 1 to 250 then riders 12, 15 & 230 drop out when I get the 251st person to enter I would give them number 12 and so on.
If i got auto enter serial number it would add 1 each time but any ideas how I could get it to fill in the gaps?