I am working on an aviation pilot database. I have a pilot form which has a sub form showing which flights that pilot flew. There are usually 2 pilots on any given flight. My two fields on the sub form are "pilot" and "copilot".
My my question is, is there a way for the master field (pilotID) to be linked to multiple child fields? ie: show all records where the pilotID is a "pilot" OR "copilot".
Thanks for for the help!!