How can I add an ID-number that always increases (by 1) each time I add a new record to a table (using a form)?
I want to always use some info from the record that was added last to fill in a different form.
The reason for my question is that I heard that the autonumber does not necessarily increase each time a new record is added...
I want to always use some info from the record that was added last to fill in a different form.
The reason for my question is that I heard that the autonumber does not necessarily increase each time a new record is added...