I've recently started using Filemaker again, and I realize that much has happened since version 4... :-)
Some memory loss on my part may also be to blame.
However, I need a script that generates an unique 3-character "password" for every record in the database. My script as of now looks like this:
If [ Length ( MyDatabase::Password ) = 3 ]
Clear [Select; MyDatabase::Password]
Set Field [ MyDatabase::Password; MyDatabase::Password & Middle ("abdefhimnrtABCDEFGHJKMNPQRSTUVWXYZ1234567890"; Int
(Random * 44); 1)
Exit Loop If [ Length ( MyDatabase::Password ) = 3 ]
This script generates passwords just fine, but how do I add a function that checks that no duplicates are created?
/Thanks for any help!