With regard to the using the primary ID. I suppose I could for example start the AUTO_INCREMENT at, for example, 100000 if I wanted a 6 digit number. the increment by 1 is not ideal but would work, until 999999 that is!
If I use the random number generator with Server Validation Unique Database Value. What will happen if the Validation fails? Will it automatically create another number?
Thanks in Advance Jason!