4 Replies Latest reply on May 8, 2017 7:55 PM by philmodjunk

    Look-up to match a field and consider another field


      Lookup value says: When a new entry is made in the field « field name », this lookup will copy the value from the first matching related record in the table “Table name”.


      Okay, but I don’t really want it to copy the value from the FIRST matching related record. I also want it to consider another field to select the most current record. I have another field in the same table which is a date field.  How can I have it lookup and match the most current record?