AnsweredAssumed Answered

Concatenating a Text  Constant With Autogenerated Serial Number

Question asked by MarkGreenawalt on Apr 26, 2013
Latest reply on Apr 26, 2013 by schamblee

Title

Concatenating a Text  Constant With Autogenerated Serial Number

Post


     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!

Outcomes