title: FileMaker - How to have distinct values listed on-screen?
body: <p>I would like to have the distinct values of a repeating field listed in another field (in browse mode). The case is as follows:</p>
  
  <p>I have a field that contains country names. The country names in this field may repeat themselves, thus when using the "List" function I get something like "France, France, France, Germany, Germany, Hungary".
  How can I create a field that lists all the values from my country field, but has it grouped as "France, Germany, Hungary"?</p>
  
  <p>In the case I could directly use a SQL query to interfere with the FileMaker databse I would use the GROUP BY statement.</p>