If i have three or four tables and i want that when a new record is entered that it is assigned a special reference, i know u can do hte auto number function, but if i do this one each and then later what to perform searches for this unique number, i will come back with a number of the same type in each table

Is it possible in some way to have some kind of letter code before the actual auto number, so that i can relate to what table its from

e.g
PLI01
PLI02
PLI03

RC01
RC02
RC03
CORR01
CORR02
CORR03

ETC?

Or would i have to manually create each one myself rather than them being assigned automatically?