AnsweredAssumed Answered

Help: Lookup

Question asked by MichaelShea_1 on Oct 24, 2014
Latest reply on Oct 24, 2014 by philmodjunk

Title

Help: Lookup

Post

Hello

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..?

 

Thank you

Outcomes