AnsweredAssumed Answered

Obtain a list of unused values from a list of possibles

Question asked by raycon on Jun 5, 2014
Latest reply on Jun 7, 2014 by taylorsharpe

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?