I'm building an application that will let a record administrator merge updates submitted by the general public with an internal record. Records include contact information, qualifications, etc. Information is captured from the general public using text fields, drop lists, check boxes, and radio buttons.
The updates are placed in a pending area. All changes to the internal record must then be approved by the administrator. Often times, the administrator will approve all the suggested changes, however there are cases when the administrator must consider the change, and possibly override the suggestion.
I started building two copies of the form side-by-side. All user submitted fields were open for editing. Changes could be applied by section (i.e. Address, Qualifications, etc.), or by field. The result was a very intimidating form with far too much going on.
What is the best way to compare the information from two forms, and merge the two forms together?