Getting information from a segundary table

Topic Labels: Base design
555 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


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,

0 Replies 0