help plz, How do i automaticlly generate an ID number?

[eyimbo]

I know that there is the auto number function, however i would also like it to generate an ID with charaters. In my table theres a first name and surname.

Say for example: Harry Potter, i'd like the ID to generate HP001

then say there's another guy call Harriet Potter, i'd like the it to generate
HP002 insead of HP001.

appreciate any help, and if it's impossible just let me know thanx!!!!

 

[pbaldy]

You must not have searched, because this type of question comes up pretty frequently. Search here for details, but generally get your 2 digits ("HP"), search for the max number associated with those 2 digits (001) and add 1 (002).

 

[eyimbo]

You must not have searched, because this type of question comes up pretty frequently. Search here for details, but generally get your 2 digits ("HP"), search for the max number associated with those 2 digits (001) and add 1 (002).

yeah thx, but i really dont understand that