5 Replies Latest reply: Sep 28, 2012 4:44 PM by mayilvahanan ramasamy RSS

    How to generate sequence number per change in a given field?

      Hi all,

       

      I have this problem.

      I have a logical table in my application.

      I want to generate Line_Number(seqNo) for each distinct value of Field "Doc_No".

       

      So for example I want the Line_Number be generated like this:

      Doc_NoLine_Number

      K1000

      10000
      K100020000
      K100030000

      K1001

      10000
      K100120000
      K100210000
      K100220000
      K100230000
      K100240000
      K100250000

       

      Thanks in advance,

      Kari