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!
Create a field JobNumber make it a number field then on Auto-Enter Tab click serial number, set the next Value to J999. Create a second another field call CustomerNumber make it a number field also and Auto Enter Tab click serial number, set the next value to C999.