I have a simple lookup task.
I have three tables. Tables one and two have the common key (Property ID). With this, I have been able to look up a date reference in Table 2 based on the Property ID.
I have a second value to lookup to populate a calculation field in Table 1. Each record of Table 1 has a date reference. I need to use this date reference which is a key field in Table 3, to look up a value reference from a second field in Table 3...?
Not sure how to do..?