I want to autogenerate employee id when user enters details of employee
Conditions:
User Selects Department which should be used as prefix.
A new Sequence of numbers must be generated for each department
Example:
DeptA0001
DeptA0002
Again DeptB new seuquence must be started
DeptB0001
DeptB0002...