I am new to Database.
i have a form with an Autonumber field and some other fields with validation rules.
If user cancels or closes the form or if record is not saved, i want prevent Autonumber from incrementing. It should Increment if a record is saved with all validation rules fulfilled.
In short I want no gaps Between autonumber Prospectively.
Plz Help.
i have a form with an Autonumber field and some other fields with validation rules.
If user cancels or closes the form or if record is not saved, i want prevent Autonumber from incrementing. It should Increment if a record is saved with all validation rules fulfilled.
In short I want no gaps Between autonumber Prospectively.
Plz Help.