AnsweredAssumed Answered

Filtering duplicate entries in find mode

Question asked by Gasar1375 on Feb 12, 2016
Latest reply on Feb 16, 2016 by 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]

Outcomes