AnsweredAssumed Answered

Search Pic Report

Question asked by kentanderson on Sep 20, 2016
Latest reply on Oct 2, 2016 by philmodjunk

This is my second Filemaker Database.  Im a Novice.  I have my database working well.  What I need help with is how to search for data related to the PIC field Please see attached.  Basically we change PIC on different Legs.  What I need to be able to do is search every record and show the flight time for a Specific PIC (pilot in command)  Ideally I need to have a report with the PiC's time and date, but for every record.  I'm thinking this needs to be done with some type of relationship table, but I'm not sure.  Please help.  I have 7 total PIC fields per record.

fm1.tifffm2.tiff

Outcomes