Unique numbering

[gunny3000]

I'm trying to create a table/query/form that will auto-generate a unique number for a specific field. i.e. "baked" field with 0001, 0002, 0003... and a "pc" 0001, 0002, 0003... and a "tc" 0001, 0002, 0003... , and so on and so on.
o
I cannot use the autonumber as this is for a Primary Key to which there could be a few in my example.

Regards,

Gunny3000.

 

[Freshman]

make use of 3 autonumber field in 3 tables but spesify the format in the form/s:

eg:
Field1 = "Baked 000" & Auto1
Field2 = "PC 000" & Auto2
Field3 = "TC 000" & Auto3

Very rough - but you should get the idea and could fine tune it