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 Number | Sample
|
|---|
| 1 | Sample1 |
| 2 | Sample2 |
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 Number | Sample
|
|---|
| 1 | Sample2 |
(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 Number | Sample
|
|---|
| 1 | Sample2 |
| 2 | Sample3 |
Is this functionality achievable in apex? can someone help me out?
I use APEX 4.2.2.00.11 version.
Thanks and Regards,
Madonna