Does anyone know whether there is a generally accepted method of generating a unique userid? The scenario is a database holding info on people with names and addresses. For example I have tried concatenating first 2 initials, surname and postcode and although it has given unique values its very unwieldly and it won’t be very useful for people without a postcode. Otherwise I could try initials conactenated with surname and then generate a number for the dups eg. JSmith01, JSmith02 etc. Is this the more usual method? Any info or directions to source material welcome.
Thanks
Karen
