AnsweredAssumed Answered

primary key- combination of auto serial number and letters

Question asked by njoyce on Sep 11, 2009
Latest reply on Sep 11, 2009 by ninja

Title

primary key- combination of auto serial number and letters

Post

I want to make a primary key that is the initials of the person and then have a serial number automatically entered.  So that if i  have a field with the person's initials (NJ for example) the primary key would look like NJ001, and the next person entered would be MC002 and so on.  is there a way to do this?  alternatively, it doesn't matter to me if it goes 001-009 or whatnot, as long as there is a unique number next to the person's initials. I tried using initials&random as the calculation, but the number was a decimal point and was way too long.  Is it possible to shorten it?

 

thanks 

Outcomes