Originally Posted by sprescott
......I realise that using autonumber should be avoided ...
Maybe I'm missing something, but I don't agree with this
Agree some application requirements may require a sequential value or some other formatting of a number (such as order number/ GRN etc) but in most cases an autonumber should be avoided?
I would suggest that there is a rare requirement to create a different means of getting a system generated number, but there are very few and far between (possibly once or twice in an app, in one or two apps).
Surely the whole point of the system generated number is to simply create a method of identifying uniques rows in a table, and it should have no intrinsic meaning.
Effectively the link points to a special case where you are trying to create a uniques key which has a specific meaning.
Personally I would contend that these special cases should be avoided - and usually can be. Providign you can demonstarte (prove) what happened tothe missing numbers than most accountants / auditors are quite happy - often this means notallowing deletions, but include some form of flag that indictaes if the row is valid.