Question:
Wouldn't be better to store a copy of Autonumber in another table and when the form safely saves the record increment the number otherwise don't increment.
so the next autonumber should be taken from the other table.
In this way there will be no gaps between Autonumber.
how would it be done.
Wouldn't be better to store a copy of Autonumber in another table and when the form safely saves the record increment the number otherwise don't increment.
so the next autonumber should be taken from the other table.
In this way there will be no gaps between Autonumber.
how would it be done.