4 Replies Latest reply on Feb 16, 2016 5:52 AM by Gasar1375

    Filtering duplicate entries in find mode

    Gasar1375

      Hello, I have a script that runs upon OnLayoutEnter where I omit all empty records and display the results in ascending order. I'm trying to figure how can I also filter out entries where BigBase::Title matches thus only displaying records where BigBase::Title is unique. Is there a filemaker way of SQl's select distinct?

       

      Enter Find Mode []

      Set Field [BigBase::Opus; "="]

      Omit Record

      Perform Find [Restore]

      Sort Records [Restore; No dialog]