Recycle an unused ID number

Hi, is there a code snippet available for the following,

a pilot joins and receives BBB002 then leaves 

another pilot joins, they are given BBB003 by the system, instead of the lowest available number.

thanks in advance

At the moment, this is not entirely possible for the current version.

What I suggest you do is go to  and put a post there for a feature request for v3. Ideally an easy way to accomplish this is to make two tables, one called _pilots (main) and one called _pending (temporary), if they get accepted, move their registration to the _pilots table, if they don’t, then delete their registration from the _pending table and the _pilots table should have the next number free for the next accepted registration. Of course, this is just one of the ways of doing this and as I said above, this is not doable in the current version without serious modifications.

Ok thanks for the reply.