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