AnsweredAssumed Answered

Could someone help define a relationship solution

Question asked by wk1966 on Apr 5, 2018
Latest reply on Apr 7, 2018 by beverly

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.