i have two sharepoint lists. First sharepoint list contains an area field (dropdown) and the corresponding respondible (person).
The other list contains the same fields and more. Now i want that when selecting the area in list two, automatically the email adress to field responsible is entered.
Thanks for your help.
I would have liked to solve it without an extra list, but i don´t think i can solve it without one.