every time I create a new record it gets a sequential reference number Like this:
(BTW this is not the primary Key)
Whilst i imagine this is fine in most circumstances, the situation i'm in sequential numbers are causing confusion particularly when a service user has multiple cases open that opened at the same time.
What Id like to do is experiment with is giving a random number to each case when it opens so there is greater distinction between multiple cases opened at the same time sort of like this:
is this possible, is there such a function ??
being an access noob I enjoy working out solutions myself what i'm after is pointing in the right direction.
Pointers hints links & suggestions please.
Code:
Me![CaseNumber] = Nz(DMax("[TableCaseNumber]", "[Main]"), 0) + 1
Whilst i imagine this is fine in most circumstances, the situation i'm in sequential numbers are causing confusion particularly when a service user has multiple cases open that opened at the same time.
What Id like to do is experiment with is giving a random number to each case when it opens so there is greater distinction between multiple cases opened at the same time sort of like this:
Code:
Me![CaseNumber] = (RandomNumber between 00000 And 99999 That Doesnt already exist in ("[TableCaseNumber]", "[Main]")
is this possible, is there such a function ??
being an access noob I enjoy working out solutions myself what i'm after is pointing in the right direction.
Pointers hints links & suggestions please.