Trying to list values and then omit redundant values
I am trying to set up a calculation field that gets values from another field in related records and then omits duplicate values. For example, in a field called "Shape," I want to access the values from the field "Vessel" in six related records that match this record. These values are: "square"; "square"; "semi-square"; "round"; "square"; and "round." In my "Shape" field, I want to appear the following: "square,semi-square,round". Can anyone help me with the calculation that would achieve this goal?
Thanks so much!---------Cora