AnsweredAssumed Answered

Auto enter number question.

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

Title

Auto enter number question.

Post

Hi

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?

Outcomes