1 Reply Latest reply on Apr 26, 2013 7:42 PM by schamblee

    Concatenating a Text  Constant With Autogenerated Serial Number

    MarkGreenawalt

      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!