When a sales rep has his or her name entered twice it is possible that some of the salespersons sales are assigned under the first name and some of the sales are assigned to the second name.

This program is used to move all the sales rep sales from the incorrect sales rep name to the correct sales rep name. The program also marks the incorrect name as deleted so that it will not be able to be used again.

The first field to select is on the left and it is the correct name of the sales rep.

The second field to select is on the right and is the incorrect name of the sales rep.

When the submit button is clicked on all occurrences of the incorrect sale rep name in the primary and secondary sales tables are converted to the correct name of the sales rep.

The incorrect sales reps status is also changed from 'a' or 'i' which stands for active or inactive to 'z' which means the incorrect name will not be displayed on any of the data entry menus and thus can not be used again.