union, join, or transposing field values into a calculated field
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