Recycle an unused ID number

[shaun105]

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

[web541]

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

What I suggest you do is go to this forum 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.

[shaun105]

Ok thanks for the reply.