Thursday, March 12, 2009

Ab-normalization at Experts Exchange - part 7

The question today:
Access copy from subform to Main form

Another "classic" example of redundant data. Why have the same field on a main and subform?
The first question I would ask before advising such a questioner is why storing the same value twice.

But, you're having a bad day when you're advised by the #1 MS Access expert at Experts-Exchange. This "expert" will give you as solution the code to move the field and won't mention the data redundancy and the trouble this can cause...

Is the questioner helped by this ? Yes, in the short term, but it's sure he'll be back and that makes EE happy as they will continue to collect their $$'s.
For smarter people there are sites like bytes.com where the membership is for free and the experts are cooperating to provide the best answers.

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23993476.html)

No comments:

Post a Comment