Stuart McLachlan
stuart at lexacorp.com.pg
Thu Mar 6 22:50:29 CST 2014
Who's got the narrow vision? You and I are saying exatly the same hting. On 6 Mar 2014 at 23:31, John W Colby wrote: > LOL. Such narrow vision. The invoice number can exist side by side > with the surrogate key. In fact many of us will tell you that if your > clients are SEEING your autonumbers you are doing things wrong. > > Autonumbers are just the mechanics of the database. They are NEVER > data. > > So yep, I would have an autonumber (hidden) and the Invoice number, > generated however you like, but NEVER used as the PK. > > John W. Colby > > Reality is what refuses to go away > when you do not believe in it > > On 3/6/2014 10:59 PM, Stuart McLachlan wrote: > > Autonumbering of visible/meaningful Invoice Numbers is definitely a > > no-no. It *will* result in gaps. > > > > Application generated Invoice Numbers according to business rules > > combiined with autonumbering of a surrogate PK for each invoice > > which end users never see is a definite "yes-yes" :-) > > > > > --- > This email is free from viruses and malware because avast! Antivirus > protection is active. http://www.avast.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >