I have a survey where you make a selection from an 'Area' drop down list. The 'Area' drop-down list contains 4 choices and you select one choice either A, B, C, or D.
I want to increment the numbering where if say you have already got 3 surveys created for choice A then the next number would be A4.
But if you chose B and B had already 7 surveys for it then the next number would be B7.
Anyone know how to do this?