title: Autonumber for document numbering request list
body: <p>We have a scenario where a user requests an "autonumber" for documents.</p>
  
  <p>There is a field where they select the "document type" when adding a new item to the list, which is a lookup field (doc_type) held in another list call "Document_Types_Lookup".</p>
  
  <p>The user could select one of up to 15 different document types when requesting a new item, and the autonumber should stay in sync with the document types...so there is no loss in the next available number for that particular document type.  This is why I can't simply use the ID column and append that to the "doc_type" field in a workflow.</p>
  
  <p>Let's say we have the following autonumbers already in the list:
  •DEMO-MATH-001
  •DEMO-MATH-002
  •DEMO-ENG-001
  •DEMO-ENG-002
  •DEMO-SCI-001</p>
  
  <p>If a user submits a request for a MATH document, the number they should get to use is DEMO-MATH-003.</p>
  
  <p>If a user submits a request for a SCI document, the number they should get to use is DEMO-SCI-002.</p>
  
  <p>I have already used the autonumber in a workflow simply putting the ID column on the end, but this won't stay in sync with the particular doc type.</p>
  
  <p>Thank you for any ideas!</p>