Need help pulling one value from a maxrow expression

[Erika_Braxton]

trying to pull a column value from a maxrow expression in a virtual column(ref type) named (table name STAT5)LAST COMMENT =
MAXROW(“COMMENTS”, “_ROWNUMBER”, ([ORDER AND ID] = [_THISROW].[ORDER AND ID]))
i have tried lost of things trying to get this value, the only one that kind of works is [LAST COMMENT].[COMPLETE?] but the app wont load bc it says its circular (which it is, because [COMPLETE?] is the name of the column on the STAT5 table im working on, [COMPLETE] is the name of the column on the COMMENTS table i want my answer from). The maxrow expression does return the key value i expect to see, so i dont think that part is my problem.

[Steve]

Is the LAST COMMENT column of type Ref that refers to the appropriate table?

[Erika_Braxton]

HOLD PLEASE WHILE I SLAP MY FOREHEAD…
i didn’t even see that it defaulted to the wrong ref table, my entire morning has been spent on this… thanks Steve