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
Does Start Date and End Date indicate that the value in the User Price field is only to be used for dates in that interval?
Would you use the computer's current date to compare to this range or a date you enter into main table?