Create A Payroll Record That Collect Some Information From Another Table

I would like to create a payroll record that collect some information from another table. In other words:

-I have an employee.
-I have a payroll table.
-I would like to get some of the values from the employee table written to the payroll table when a new record is entered.

The form would look some thing like this:

Three boxes:

Employee: [ ] (table query to find name) # of students [ ] #of class minutes [ ] (value list with 3 choices)

When the SAVE button is pressed a record would be written to the payroll table with:

The payroll table would look like this:
payrolid#, employee#, employee, # of students, # of class minutes, rate, date

The employee#, employee and the rate would come from the employee table.The # of students, # of class minutes and date would come from the payroll form.