title: Sugar CRM, Getting auto increment value in the custom field
body: <p>I am using Sugar Professional 6 and also checking the same in community version.
  In project module, I have project Name which should generate automatically from another field called MSO with the prefix and auto increment number.</p>
  
  <p>For ex.</p>
  
  <p>MSO Code- <strong>Xyz</strong>
  Project Name should be- <strong>Xyz1</strong></p>
  
  <p>For next record</p>
  
  <p>MSO Code- <strong>Abcd</strong>
  Project Name should be- <strong>Abcd1</strong></p>
  
  <p>MSO Code- <strong>Xyz</strong>
  Project Name should be- <strong>Xyz2</strong></p>