random

[madman411]

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!

[Raybaudi]

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.

[Lee Smith]

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