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?