Increase field value incrementally

[ppataki]

Dear All,

I have a field in a table that needs to get updated incrementally when a new record is opened in the table
The first value needs to be 1 then for the second record 2 etc etc
(integer values)

I know that there is an AutoNumber field type but that does not get reset when data is deleted from the table...

Could you please advise?
Many thanks in advance!

 

[namliam]

It gets reset if you do a repair and compact....

Failing to use the Autonumber you can do it yourself... Search the forum (references) for some examples.