Creating a table from 3 other tables

[swamija]

Hi

I am new to AppSheet application for budget creation. 

Three input tables

- Month (Just 1 -12)

- Month_ID

- Employee hours by department

- Employee

- hours

- Employee Department

Salary

- From period

- To period

- Salary

- Hours per week

Output table - Budget

- Month

- Employee

-  Department

- Amount

I need a routine to create all records in the budget table with something like this

---

Month = 1

([Employee hours by department].[row_id] = 1

(

insert budget.amount = salary.salary*[employees hours by department].Hours/[salary].[hours per week], month = Month.month, employee = [employees hours by department].Employee

where salary.From_Period>= Month,

salary.To_Period<=Month,

salary.employee =  [employees hours by department].Employee

)

 [Employee hours by department].[row_id] = [Employee hours by department].[row_id]+1)

Month = Month+1

Sorry, I am not explaining this well but I just want these three table to be used to populate another table.