Concatenating a Text Constant With Autogenerated Serial Number
I'm creating a database for tracking customers and jobs. I need to generate Customer numbers as "C999", where 999 is an automatically generated serial number. Similarly, I need to make the Job ID in the same format "J999". It seems I can either get the serial number to work, or the "C" (when creating a new record). But I can't get both working at the same time. Rather than detail what I've tried, I'd like to hear how it SHOULD be done. Thank you!