AnsweredAssumed Answered

List of names in a field, without duplicates

Question asked by walt105 on Jun 6, 2016
Latest reply on Jun 6, 2016 by walt105

Hi, I am new to Filemaker (15) and I am stuck with the following issue:

 

I have created a database of exhibitions and artworks, with two tables. One with exhibition details and one with artwork details, including artist names.The key between the two tables is an unique exhibition ID.

 

On the exhibition layout (It relates to one particular exhibition) I would like to have one field that lists all the artist names of those who exhibit in exhibition E, but I do not want names repeated if the artist features with more than one artwork.

I tried this: I created a summary field with the option: list of [name of artist field]

This results, on a field in the exhibition layout, in a list of artists in exhibition E, but it lists artist A multitple times because he/she features multiple times.

Also, ideally, I would like to format the summary of names as Artist A, Artist B, Artist C, etc., that is, not a vertical list.

 

I looked through questions that look like mine but have not found (or recognised?) a solution yet.

Any suggestions would be greatly appreciated!

Outcomes