I have 2 tables. In table 1 there is a date field and an amount field. Table 2 has a start date, end date and value which I'd like to use in a calculation against the amount field in table 1. Table 1 will hold the results.
If the date field in table 1 reports Jan 15 2018, I'd like to have FM lookup the value that corresponds to that date in table 2 which has a value that is identified as falling between Jan 1 2018 and Jan 31 2018 and perform a mathematical action.
I look forward to the responses.