Does anyone know if there is a way to change the member ID that is assigned to someone when they purchase a membership?? I would like to customize the number that is assigned and make it a much larger number, because they are being used with insurance companies and are being printed up on cards for fulfillment purposes... Is there a way to have something other than a sequence of numbers starting at 1...?? Any help would be appreciated.... Justin
Yes when you create the table you can of course you would have to change the SQL file BEFORE installing it. if you already have a few customers in there you could run a back up delete the table then create it again with the updated table to include auto increm to the starting number you want.
Are you just doing this to create a larger number to print on the cards or are other people going to be able to use these larger numbers somehow. If it is just for your own use and you simply want a larger, random, number then take the original one and multiply it by a fixed number such as 34567. Then to locate the original number on your own system simply input this larger number and divide it by 3456. So real membership number is 47. Print 47*34567 (1624649). Then input 1624649 and lookup (1624649/34567) or 47. That way everything is carried out in say PHP with no modifications to aMember scripts. If you want consecutive large numbers then simply add a large number for printing and when inputting take this number away and what is left is the original allocated membership number.