membership number creation
I have a membership form and I am wanting a unique number created automatically for each record which will be the users membership number. I am testing this with 'security assists' 'random password' with a numbers only 6 digit format. Can you tell me if these numbers will always be unique? Subsequently is this a good way of automatically creating a membership number for the user or is there better way of doing this?
Thanks in advance!