1 2 Previous Next 18 Replies Latest reply on Aug 30, 2016 8:00 AM by realgecko

    Consolidated list unique values only


      Dear all,


      I am working on a database of Mexican medicinal plants for my PhD thesis.

      Being new to filemaker I am encountering some issues and would greatly appreciate any sort of advice.


      I set up relationships between three tables as can be seen from the screenshot below. In the plants table, I would like to create a consolidated list of the studies in which a specific species occurs; Using the function

      Substitute ( List ( combined_data::Study code ) ; Char ( 13 ) ; ", " )

      In theory, this worked well as can be seen in the screenshot from the table plants below. However, as in the combined_data table specific combinations of Study code and Scientific_Name can occur more than once (i.e. a specific botanical species can occur more than one in a specific study), the List includes duplicates.

      Is there a way to set the criteria for the list function to include unique values only?


      Thanks a lot in advance!

      Screen Shot 2016-08-28 at 5.04.07 PM.png



      Screen Shot 2016-08-29 at 12.52.49 PM.png

      Screen Shot 2016-08-29 at 12.54.32 PM.png

        1 2 Previous Next