INSERT INTO field using three different tables

[gehrenfeld]

I have three different tables. hours, salary, and pay. In the hours' table, one field is named regular, in the salary, one field is named regular, and in the pay table, one filed is named regular.




On the input form where I enter the hours, I have a button named update pay. When I click on the button I want to INSERT INTO pay.regular = hours.regular * salary.regular


I have tried JOIN, UNION, AND INNER and can not get it to work.


What is the correct DoCmd.RunSQL statement to accomplish this?

[mike60smart]

Hi can you upload a zipped copy of the db?