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.