>IMHO, during the save-you will have fewer unused numbers scattered throughout the system if the user aborts adding a record after the number has been generated. However, in this case do no use the autonumber as a PK but have a separate GUID or other PK of course.
This can be a problem, or not, depending on what type of PK you use. If you use PKs which the user never sees, unused (skipped) numbers are no problem at all - the only requirement for the PK is that they be unique.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)