Auto-entered Unique PrimaryIDs

[Ugo DI LUCA]

Follow up...

I tried the following and it appears to be working. I thought I should report it. I used the global as a related value from a constant relationship.

It works.

Am I the only one to feel that this is odd ?

So

Right( "0000" & Status(CurrentRecordID); 4) & ::Constant:global &

Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ"; Round(Random*35;1); 1) &

Right( "00000" & Status(CurrentTime); 5) &

Middle( "0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ"; Round(Random*35;1); 1) &

Right( "000000" & Status(CurrentDate); 6) &

Middle( "0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ"; Round(Random*35;1); 1)

gives me correct result for an UniqueUserFriendlyRandom ID.

[digitalchaos]

Can we please have an example file of this technique that you implemented Anh_Tran for reference i would like to see how you set the primary number as in daniel's calculation and as in capkurt thanks