May 13, 200619 yr Hi all, Is there a way for FileMaker to generate a random number (4 digits preferably) in the field of my choice when I create a new record? I don't know if this is possible, but for it to only use that 4-digit number once? I don't want half the clients listed in my database to have the same client number. Thanks!
May 13, 200619 yr Hi "random" numbers can repeat, as you certanly know ! So go on with autoenter a serial... this can start from 1000, if you want 4 digit numbers or even from 0000 if you want 4 digit text.
May 13, 200619 yr Hi Daniele, I started to answer this earlier and got waylaid. The only thing I would mention is If there is already a field, use the Replace function in the Browse Mode to update the existing records before creating the Auto Enter. And make the field a Text, and then you can use 0001. HTH Lee
Create an account or sign in to comment