How do I get the data from the portal records into a text calculation? I only get the first portal row data?
I would create a record in the child table that tests for a score and creates the string.
Detail ( case ( IsEmpty ( No Show ) ; "Date:" & Date & " Score: " & Score ) If you want the labels as small as your example then use Text formatting to reduce the font size of the labels
In the parent table create a field to display. DetailDisp [ List ( Portal Relationship::Detail ) ]
Thank you. I really appreciate it.
Here's a little sample – along the lines of PSI's suggestion – that may give you some creative ideas.
Have a look a my post here: https://fmdev.filemaker.com/message/147388#147388
Retrieving data ...