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 ?