Set record counter

[tanz]

I have a customised table u_audit which inserts the INC record number whenever the INC is updated.For this I have created a customised string field(u_number) which captures INC number and I have created a customised field (u_count) on the audit table and I want to insert the counter(1,2,3,4,5...) on basis of insertion of INC record. For examples: when INC record is updated for 1st time a record should be inserted in u_audit table which populates u_number as INC number and u_count should be 1 and so on. Please can you let me know how to achieve this.

[Abhijit4]

Can you share data screenshot from audit table. and example incident that you testing.

[Anil Lande]

Please test with new record, old record is corrupted already.

[Abhijit4]

Can you share data screenshot from audit table. and example incident that you testing.

[tanz]

Thanks I have corrected it and it works perfectly now

[tanz]

Just one question, will the above work from start if the assignment group also changes but INC remains same . 

Example data:

Number Assignment group           Follow up

INC1      XYZ                               1

INC1       XYZ                              2

INC1       XYZ                              3

INC1       ABC                                1

INC1       ABC                                 2

If not, please can you help me to modify this