On Mon, 20 Jan 2003, Albert P. Calame wrote:
Again, we found that the brief records we entered for later enhancement never got enhanced.
Is some sort of data auditing facility available in these packages to say "these records are incomplete"? In dealing with migrating legacy data into relational databases I've had to write these sorts of auditing scripts to gradually clean up the old data. Sometimes this is before loading into the relational system, but often it happens after it's loaded. A flag that says "this record is incomplete" or simply a series of checks "if x then problem" have been effective if the users are motivated to clean up the data problems found in the audit. -- </chris> "Never offend people with style when you can offend them with substance." - Sam Brown