5 Digits increment AlphaNumeric

[Guest]

I have a form with three fields.
Last Name
First Name
Tracking

What I like to do is any time the last name field recieves data the tracking
field automatically increment a 5 digits alphanumeric value. Help please

Thanks in advance.

Mike

 

[Steve Schapel]

Mike,

You mean when you add a new record? What is the structure of the data
in the tracking field? Can you give some examples? And an explanation
of what increment would look like in these examples?

 

[Guest]

This is how its goes.
I have three fields in the form.

"Last Name" "First name" " Tracking"
As last name is enter the tracking field automaticially generate "YY001"
YY is the year
Like
05001
05002
05003

0500A
0500B

and so on.

Next year it will be

06001
06002

0600A
0600B

Thanks in advance..
Mike

 

[Steve Schapel]

Mike,

Sorry, we still haven't got it. I am guessing that you go to 0500A
after you get to 05999, am I right? And then, what happens after 0500Z?
050AA?