I have 3 columes in my table formatted as such: A Linked record field + 2 look up fields from the linked record. (crossed out proprietary info)
this linked record field shows all clients that been accepted by this playlist. The client may show up multiple times if they have been accepted by the playlist more than once or for different projects. This is fine.
The problem then comes in the artist genre and genre/moods look up fields which reference multiselect fields from the a different table. The genre and moods fields will list multiselect values multiple times because of the multipile records that have been accepted by the playlist. I am trying to show unique values for these two look up columns, but cannot seem to figure out how.