Can FM generate random passwords containing both "alphabetical" and "numerical" units? For example: f3ds4s2

I've figured out how to generate random numerical "PIN" numbers. For example:

Round(Random* 10000, 0)

However, I'd like to have FM also generate passwords in the formate listed above. Can this be done? If so, how?

Thanks!

gCharacterList = "0123456789abcdefghijklmnopqrstuvwxyz"

Char1 = Middle(gCharacterList,Int(Random*35.999)+1,1)

Char2 = Middle(gCharacterList,Int(Random*35.999)+1,1)

Char3 = Middle(gCharacterList,Int(Random*35.999)+1,1)

Char4 = Middle(gCharacterList,Int(Random*35.999)+1,1)

Char5 = Middle(gCharacterList,Int(Random*35.999)+1,1)

Char6 = Middle(gCharacterList,Int(Random*35.999)+1,1)

Password = Char1 & Char2 & Char3 & Char4 & Char5 & Char6

Bob,

Thanks for the reply. Where do I place this code?

-David

It depends how and when you are assigning the passwords. I assume you are using a script. If so, then make all of these global fields, and then use "Set Field" commands in your script to assign the values to Char1...Char6 and Password. The value of gCharacterList can be preset to the text value shown when you set up the database.