1 2 Previous Next 29 Replies Latest reply on Jun 7, 2014 6:27 PM by taylorsharpe

    Obtain a list of unused values from a list of possibles


      Hello all,


      I have a problem. (don't we all)


      Say I have a membership solution where the members registration number is NOT their primary key. There is a range of possible numbers from 1-9999 , and every time a new member is added the user needs to be presented with a list of only those numbers not already in use. I have tried relationships, SQL, and scripting, but all seem to be execeptionally slow.


      Does anyone know of a really fast method?



        1 2 Previous Next