Subform connected with 2 fields

[Mtyetti2]

I have a pilot database which uses a subform to log flights. The 2 fields I need to relate to the master form is 'Captain' and 'CoCaptain'. I can see in the properties of the subform, I can link one of these fields to the master field. Is there a way to make an 'or' statement somewhere, so that the subform can return results where the pilot is either the Captain or CoCaptain?

The Master form is the pilots, and the subform is the events flown by that pilot.



Thank you so much!

[orange]

Can you show your tables and relationships as a jpg?

Usually with Form /SubForm you have a 1 to many relationship
eg
A Pilot flies Many Flights

So in your case, What is the data associated with your mainForm?