need a Autogenerated ID field in form
<p>This all will happen when the user hits the submit button</p>

<p>My requirement : ID Format should be FF-YY-00001-A (this is the field of the table)</p>

<p>1 FF is the shortcut Name</p>

<p>2.YY is the Current Date and I want to save this in table as year field ,so that it will help to track down the reports, condition: I have to take the last part of the year ie suppose 2013=> 13 2014=> 14 </p>

<p>next field is autoincrement field ,for this it should be generated and incremented by one 
I m thinking ,this value can come from the autoincrement field from table like Serial no. like sr.no=1 we can take this field 00001 or 1 00001 (should be better if we can)</p>

<p>also we have to increment this value to 1 [* We have to get the previous value for the comparision and we can do with help of last record and field sr.no]</p>

<p>4.A/B/C/D is the option from the user</p>

<p>After this all </p>

<p>now our ID should be FF-13-1-A next: FF-13-2-B next entry: FF-13-3-C </p>

<p>Note: We have to consider the Dash (-) also ie our ID Format includes Dash ie (-)</p>

<p>After Submit Button : </p>

<p>a) ID Field will be updated example: FF-YY-00001
b) Autoincrement field Sr.no gets the value example: like 1 c)year field will be updated example: like 2013</p>

<p>Hope u will understand the requirement</p>
