[AccessD] Membership File Changes

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
> 




More information about the AccessD mailing list