I have a table that lists “People” in different categories (by role) and includes contact information for all of those people.
For Department heads, I would like the email address of their Executive Assistant to populate in a field in their record.
So I would like Bam Bam Rubble’s email address to show up in the box circled in green:
I have a second field of “Organizations” that these link to that looks like this:
Is it possible to do what I want and have Exec Assist emails appear in the records of their department heads?
Thanks so much!