iterating over child rows to create a string

[dipto]

I have one order table with ref to items. each row in the order table has many items (reference, part of).
Now in an action, I want to form a string that says item name and quantity for each item for that order(from the context of order table). Still now haven't find any way to achieve this. Any help would be appreciated.
Example

Order : (id, description, list of items)
               ORD-2022-11/2, TestOrder, [ITM-1, ITM-2]
Order-Items: (id, name, quantity, price)
                         ITM-1, testItem-1, 2, 100
                         ITM-2, testItem-2, 5, 23
Expected O/P - 
"Req:
    testItem-1, 2 pcs
    testItem-2, 5 pcs
 Total:"

Thank you in advance 🙂

[dbaum · Accepted solution]

In the child table, create a column (can be a virtual column) that concatenates within each row the values you want. In the parent table, use that column (e.g., [Related Order-items][New Column]) as the list content in an expression that transforms the list into the text you want.