1 2 Previous Next 21 Replies Latest reply on Mar 11, 2014 10:26 AM by rukbat

    Auto Generating Serial Number in Tabular Form

    Madonna

      Hi All,

           I need to implement Line Number concept as in Oracle Applications in my Apex Tabular Form,

      (ie):

      If I create 3 records in the tabular form it should appear as shown below:

      Line NumberSample
      1Sample1
      2Sample2

       

      The Line Number has to be an auto generated series and should be a database column (ie) it has to be display as text(saves state) column in the tabular form since it cannot be modified by the user.

       

      In case I delete a record then it should be as shown below"

       

      Line NumberSample
      1Sample2

      (ie) though I have deleted the First record it should automatically change the Line number of the second record to 1.

       

      and if I update the tabular form by adding another row then it should appear as shown below:

       

      Line NumberSample
      1Sample2
      2Sample3

       

      Is this functionality achievable in apex? can someone help me out?

      I use APEX 4.2.2.00.11 version.

       

      Thanks and Regards,

      Madonna

        1 2 Previous Next