3 Replies Latest reply on Oct 24, 2014 3:38 PM by philmodjunk

    Help: Lookup

    MichaelShea_1

      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