auto function in access tables
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?
|