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?