Calculation resulting in text string assembled of related field contents

[capisco]

Apologies, as this is no doubt simple, but I haven't figured out the vocab for an effective search, hence my question:

Project Table

project serial #

Event Table

project serial #

event date

event detail

There are multiple Events/Project. I'd like a calc field in Project to string all the related Events as text (event detail1, event detail2, event detail3, etc). What could be easier?

It would preferably deal with commas, and would ideally put them in the right order (reverse chrono), but for now I'll take ugly and alpha if it works.

Many thanks in advance, /capisco

[comment]

Try =

Substitute ( List ( Events::EventDetail ) ; ¶ ; ", " )

Events will be listed in the sort order of the relationship.

[capisco]

Brilliant! I am amazed there's multiple things in this solution I don't fully understand. I will investigate, but thus far it seems to behave perfectly, many thanks, /capisco