AnsweredAssumed Answered

Conditional Summary Field - Summary UI, Script or Table?

Question asked by danielgrimes on Dec 12, 2018
Latest reply on Dec 12, 2018 by philmodjunk

Hi - I' very new to FileMaker and have tried to search for an answer, but I don't think I've found one.


I have a table of race results (Results).  It contains three fields:

  • Racer No (Foreign Key from the Racers table)
  • Race No (Foreign Key from the Races table) and
  • Time (for each racer)

There are many races held, with many racers in the race.  I want to produce a summary field that shows the fastest time for each race.  I've done a summary field through the Summary Field UI (=Minimum of Time) and this gives me the fastest time for all records in the table.


To incorporate the month Race No as a condition to the summary, I'm thinking that I might have exhausted the capability of the UI (or have I?) and maybe I need to build a calculated field, a script or build a summary table?


Help much appreciated