Displaying data from an unrelated table

you can create a field on appointments which concatenates the fields together with all the relevant details in one field.
If you want the results to be sorted by date, then I suggest that the first part of the string be in the format YYYY-MM-DD.

Then use a Combined text summary field on the relationship to float up the appointment details to the Patient.  Then use a formula like this to convert it to a vertical list.

SearchAndReplace(ToText([My Combined Text Summary Field]), " ; ", "\n")

Then look that up down to Procedure Authorization.


------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------