Hi
I have 2 tables as shown below. I want to look up the "Field" column in Table 2 and and update the record in Table 1 for the column mentioned in "Field column of Table 2 based on most current "System Notes Date".
For Example: In Table 1, for document number OPP1003, "Exp.Close Date" should...