Ugo DI LUCA Posted June 21, 2003 Share Posted June 21, 2003 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. Link to comment Share on other sites More sharing options...
digitalchaos Posted July 22, 2003 Share Posted July 22, 2003 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 Link to comment Share on other sites More sharing options...
Recommended Posts