Passwords?????????

[harrrrrrry]

Don't know where to put this question but here it is.

I have a database of 600 contacts Name/ address/ phone/fax/ etc

I have set up two fields username and password

Username is not a problem

Is there any way of generating a random password for each one within filemaker?

[jscooper]

If you ant use use pre-defined passwords, you can have a file of them, then write a script to go to a random record number, copy the password, mark it as "used" and paste it into the person's record.

Or, you can use a loop to generate a radom string. Such as

go to record/request [first]

loop

loop

exit loop if length(password) > 5

set field [gAlpha,"abcdefghijklmnopqrstuvwxyz1234567890"]

set field [password,password & middle(gAlpha,int(random*36+1),1)]

end loop

go to record/request [next, exit after last]

end loop

(or something like that).

Jeff