AnsweredAssumed Answered

Look-up to match a field and consider another field

Question asked by genman on May 8, 2017
Latest reply on May 8, 2017 by philmodjunk

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?