I’ve got a table: SCOPE and a table: NOTE (These are not reference together, and I do not want a helper virtual column. My data sets are very large.)
I have an action on the SCOPE table to LINKTOFORM to create a note. On Save I am attempting to pass that note to a column on the SCOPE table “scope_current_mgt_note” I am using an action to “Execute an action on a set of rows” And then I have my data change action, When I simply put in the MAXROW expression, it injects the correct row ref number. However, when I wrap it in a LOOKUP() it pushes a null value.
NOTE[note_text], MAXROW(“NOTE”, “note_datetime”, [note_REF_table]=[_THISROW])=[note_key]