Autonumber field to create another field in base36.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am wanting to take the autonumber assigned to a new record and in a second field, convert that number into a base36 format. My database is forced to be limited to only 3 characters in that second field and so I needed to maximize my results with base36 (A-Z, 0-9).

If there is another way to keep such a strict controls on records that will have high visibility I will take suggestions.
 
Xiaantin said:
I am wanting to take the autonumber assigned to a new record and in a
second field, convert that number into a base36 format. My database
is forced to be limited to only 3 characters in that second field and
so I needed to maximize my results with base36 (A-Z, 0-9).

If there is another way to keep such a strict controls on records
that will have high visibility I will take suggestions.
Click to expand...

While I know what base 36 is, I am not at all sure exactly what you are
tying to do. So I am running a little blind.

I suspect that rather than use autonumber you should construct your own
numbering system to create the results you want.

It is never a good idea to use autonumber in any application that the
user will see that number. It does nothing but cause problems. Just read
back over the last week or two and see how many questions and problems are
caused by using autonumber for anything other than a unique number to join
records.
 
Back
Top