My application has a main form and two subforms. 

Main form = deployments 

Subform 1 = incidents - incidents responded to during each deployment. 

Subform 2 = staff - employees who worked on each deployment. 

I have successfully linked the relationships using the main form's ID. 

The main form uses a look up field to show which employees were deployed on a given day. Then the Incidents form has a lookup to show which staff responded to which incidents. 

The main form has a formula field calculating the number of hours for each deployment (end time - start time = “total”). 

The staff form also includes a field showing the employee’s name as well as their hourly rate. 

What I need is a way to multiply the total of number of hours each employee worked by their hourly rate. 

Thoughts?