I need to have a form update information on two tables. This database is used for peer evaluations. I need to know if all employee are entering the data. I need to be able to have the date the form was submitted, the month the evaluation is for, and the person they are evaluating to populate into two different table. Because they are promised this is confidential we are created a linked table with the submitters information for tracking purposes only. This table can't contain any of the scoring information, just as the scoring table can't contain the submitters name.
I have this being done now by having the employee click a button after filling out the evaluation, that then opens a second form where they have to put in the month and the person they are evaluating again. Since we have this split I can not be 100% sure they are putting the right employees name when they say they finished an evaluation.