You have to make a compliant register table from sql server
Compliants(CompliantID,Comp.Date,IpAdress,ProblemDesc,RespONSIBLE)
Compliant ID to be generated automatically as.If Resp. is Management Start with
M001(CompliantID)
like that..
If Network Person is responsible start with
N001(CompliantID)
if Others are responsible start with
O001(CompliantID)
like that.
With the help of stored procedure
It is done when i am insert a record,
if i give RespONSIBLE field as management it should generate the
CompliantID(AUTO GENERATE) as M001
OR
if i give RespONSIBLE field as Network Person it should generate the
CompliantID(AUTO GENERATE) as N001
if i give RespONSIBLE field as OTHERS it should generate the
CompliantID(AUTO GENERATE) as 0001
AND WHEN IAM TRY TO INSERT NEW RECORD IT SHOULD INCREMENT AS M002 OR N002 0R 0002