Getting information from a segundary table


I have tables that are linked that way (I shall make it simple) :

Contacts - with fields : Contact Name / email
Missions - with fields : Mission Name / Contact Name (lookup from table Contact)
Invoice - with fields : Mission / Contact name (directly from the lookup in table Mission) / Contact email

My difficulty is in the table Invoice :
I would like to have the “Contact email” coming up directly when I select the Mission, How can I do that ?

Thank you,

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.