Steve,

While I do like the article that you wrote, I would like to point out that you never defined PII ( Personally identifiable information ) in it.  I am sure...

SCC_Addicted

1. Their can be many HeadQuarters ( Safeway, Albertsons, KingSoopers, WalMart, etc. ) so a null in the HeadQuartersID field of the Location Table...

PW

     Thank you for your reply, but why would you want to leave this for programmers to have to remember to do.  I thought that that is why triggers were...