Jan 08, 2024 09:07 AM - edited Jan 08, 2024 09:17 AM
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 !
Solved! Go to Solution.
Jan 08, 2024 11:00 AM
Jan 08, 2024 11:00 AM
Hi,
use lookup field
Jan 08, 2024 11:34 AM
That was it, thanks.