Combine contents of text field from two records

[funhawke]

I am having difficulty finding a function that will allow me to combine the contents of two fields from two differnt records. Record 1 and 2 both contain a text field Game_Results. Record 1 Game_results contains "Moose 1 Hellmovers 2" while Record 2 Game_results contain "Pushers 2 Condors 6" I need the result to equal "Moose 1 Hellmovers 2, Pushers 2 Condors 6"

Is there a function that will do this?

[mz123]

Try the GetNthRecord function.

How are the two records related? Or are they just sitting next to each other on a layout?

[funhawke]

The two records are game summaries. Their common link is the game date.

[mz123]

Try...

Substitute( List( Summaries::Description ) ; ¶ ; ", " )

Where "Summaries::Description" is your related field from the Game table to Summaries table.