I have two forms - an Event form and a Volunteer form
Event form has Event Name, and includes Coordinator Email Address
.
My Volunteer form has lookup to Event form.
I want to create a field so when the Event is selected I also pull in the Coordinator Email Address so I can send an email notification to the Coordinator when a volunteer signs up
What is the best way to do that?