darrelhawes
Technical User
Hi,
I'm trying to populate a field with wage data. I have a field linked to an "employee" table; the particular employee can be selected from the drop-down box. I then enter the hours worked in the next field. Then I want Access to look back in the employee table, find the wage rate for that employee, multiply it by the hours worked value that I just entered, and enter the result into the "wages" field (linked back to a transaction table).
In my research thus far, I haven't been able to figure out how to accomplish this. What is the best way to make this happen?
Thanks,
Darrel
I'm trying to populate a field with wage data. I have a field linked to an "employee" table; the particular employee can be selected from the drop-down box. I then enter the hours worked in the next field. Then I want Access to look back in the employee table, find the wage rate for that employee, multiply it by the hours worked value that I just entered, and enter the result into the "wages" field (linked back to a transaction table).
In my research thus far, I haven't been able to figure out how to accomplish this. What is the best way to make this happen?
Thanks,
Darrel