Masking an ID

[AlexH113]

Hello everyone,
I have a question regarding ID's and masking them.
I am designing a DB where we entre information on people who attend our
annual meeting.

My boss would like for a certain attendee to reflect the area that they are
from just by looking at their ID on the DB.

For example:
John Doe - from Hartford, Connecticut.
So the ID would be "cthf01" (ct=Connecticut, hf=Hartford, then whatever
number John Doe happens to be registered in the system).

Is there any way to do this?
Thanks

 

[KARL DEWEY]

I think the best way would be to put the 'cthf' in a separate field and then
concatenate them in your query, form or reports.

 

[Dale Fye]

I assume that you probably have fields for State, and City in your datebase.
With a table for Cities and one for States, or a combined table that contains
both the City and State values (along with the appropriate abbreviations).
And that you store this information with each persons individual record.

Why not just provide that information in full text (on the form or report)
rather than trying to create some cryptic ID that most people won't be able
to read. Does your boss expect to be able to remember all of the state/city
codes from memory?