AnsweredAssumed Answered

Auto enter number question.

Question asked by Charlie999 on Dec 16, 2011
Latest reply on Dec 16, 2011 by Charlie999


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?