I have a Parent object (Orders) with a Child object (States). The Child object is using the standard Name field as the "State" field.

I want to list all the UNIQUE states in a concatenated Text field on the Orders object.

My business allows for the same "State" to be related multiple times to the Parent but I only want to show each State one time in the text field that is populated by the trigger.

I'm a newbie when it comes to Triggers any help would be greatly appreciated!

I have a Parent object (Orders) with a Child object (States). The Child object is using the standard Name field as the "State" field.

I want to list all the UNIQUE states in a concatenated Text field on the Orders object.

My business allows for the same "State" to be related multiple times to the Parent but I only want to show each State one time in the text field that is populated by the trigger.

I'm a newbie when it comes to Triggers any help would be greatly appreciated!