Return to FileMaker.com
list without duplicates?
I have a note database that stores notes from many people. Multiple notes per person.
I would like to have a master list of only the names, but without all of the duplicates...so I may choose this person and then see all of the notes associated.
Is this possible?
Thanks in advance
If you make a Value List based on that field it will only show each name once. You could then attach that value list to a global field and use that field in a relationship to the table of notes, and display only that person's record.
Retrieving data ...