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

    raycon

      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?

       

      Ray

        1 2 Previous Next