Solved: Dynamic Inline Table View Display Name - Page 2

sarah_t · 10-27-2020 07:00 AM

I would like to have the Display Name for my Inline View show the Inspection Order Number, [IORN] for all of the records in the inline view. These records are the child records of a parent record with a key column [IORN]. I have attempted the following expressions but I am aware that there are certain column constraints with an Inline View Display Name verses a Form or Detail view. I have also user [_THISROW] in my lookup to reference the parent record but get an error that it cannot find the column (probably because of the Inline View Display Name constraints.

CONCATENATE(ANY(SELECT(LN_QMPTC100[IORN], ([IORN]=[IORN]))), " ", “Test Data”)

CONCATENATE(LOOKUP([IORN], “LN_QMPTC100”, “IORN”, “IORN”), " ", “Test Data”)

These expressions both produce an Inspection Order Number but the wrong one.

For example, “RIO0000032 Test Data” is the output while the actual [IORN] value for all of the related child records is “RIO000193”

Thanks!
Sarah

sarah_t

For anyone who may need a workaround, I have decided to use the “Group by” view option for the Inline table and group by the column IORN. This gives me the visual Inspection Order Number at the top of the view for all of the related test data for that order.

View solution in original post