Here I want to create JOBNO for my application for each order. Every order has different customer, quote no, address…etc.
JOBNO= MUM XXXX 01 1415
First 3digit =coming from port code data table (I already created table field)
Next 4digit = serial no (ex:0001).which is auto generated one by one .but here next 2digit assumed as current month .every month start the serial no has to begin with origin no(0001) and again ends in end of the month.
Next2digit=current month
Last 4digits=financial year (ex2014:2015) last two digits (1415).
Condition:
When I choose the port name from dropdown list like before code is auto generated and place it to the JOBNO textbox.