Related calculations with date blocks
In my solution I have different users with different hourly rates.
Table 1 shows the main table but I would like to calculate based on a record from the related price table.
Main tabel User tabel Price tabel
ID ID ID
User --- User_Account --- User_Account
When a record is created in the main table the calculation must count basis on the user account and the date that is filled in in the record the hourly rate of the user dated on the date blok between start_date and stop_date in the price tabel to finally make the following calculation.
Main Tabel::Number * Price tabel::Price = Total