>While I wish we could have a candidate key to prevent this, it's not the company's interest.
Why?
That's one of the strangest statements I've ever read...
If it's because "the company" doesn't want to use databases (DBCs), you should know that you only need a DBC to use Primary keys - Candidate keys can be used on free tables.
Insanity: Doing the same thing over and over and expecting different results.
