I have a table called inventory table where the inv_id is the primary key.
I would like to increase the counter when a new inventory has been
key-in to the user form.
Initially, the form will begin with counter=1. The counter will increased
gradually when the inventories have been entered.
If the user cancel to add any record at the initial stage or later,
the counter can trace back to previous. E.g 1->0 or 5->4
Please help me to know about how to implement counter which is very
common in every application developments.