Hi,

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,

Delphine