union, join, or transposing field values into a calculated field

Content

Hello,

We have the ability to assign several counties to a single incident, as some incidents are about things that affect several counties, for example, a spill on a highway at the county line would affect 2 different counties.  My client wants a single line description of "spill in " county.name " and " county.name for reporting that needs to be done to other agencies.

Is there any way to take something stored in a 1 to M relationship and get the M portion to be one field value as a calculated field?

For example two records stored as:

• Ashland County
• Cuyahoga County