I am trying to create a payroll package for my company, but am having a few dificulties.

I wish to copy the hourly rate from a table called "Employee details" to a table called "Weekly History"

I am wanting this to hapen after I enter the appropriate employee number when using a form called "Weekly input"

The reason for this is the hourly rate may change from week to week, but i need it to be in the record for that week/that employee as I need to do calculations using it.

Can any one help?:)