Assign Values to Multiple Projects from Multiple C...

[PMoby]

Hello,

Not sure if I overlooked the obvious, but I could not do the following which seems simple :

I have a table with contacts (persons) with their mail, function etc. They are linked to 1 Company in the companies tables, companies which have an address and Zip code. I need to display a list of all contacts filtered by the Zip code entered in Filters: how can I retrieve that value from their company ?

I already placed all companies in a nice Googlemap addons so salespersons can visualize where clients are, but values were all in the companies table, whereas here I need to show the contacts emails to reach them if someone visits their region. 

Thank you !

[Alexey_Gusev · Accepted solution]

Hi,
use lookup field

[PMoby]

That was it, thanks.