One thing I do to try and control incomplete records and bad data first is build data entry wizards or assistants. This is a flat file database that holds all the fields. Then I build in all sort of error checking. This opens all the related fields and puts all the information in the right places. This way, I have my clean data and have a backup just in case anyone goes frantic on me.
All trademarks are the property of their respective owners.
Unauthorized reproduction in any form is strictly prohibited without prior permission. Consequential and incidental damages are expressly excluded.