witchypaws
Member
Hi guys
I have a database join dropdown field xfco_introductions___intro_specialist_name which gets the name of a person from the table and field xfco_specialists___spec_name
That is returning the value I want in the form
In the same form, I would like to have a calc field that returns the email of the same person the email is found in the table and field xfco_specialists___email
How would I do this please, I don't want them to have to select the email from another dropdown, I want them to choose the person, then the next field just populates the email address for that person but grabs the data from the other table.
Thanks
I have a database join dropdown field xfco_introductions___intro_specialist_name which gets the name of a person from the table and field xfco_specialists___spec_name
That is returning the value I want in the form
In the same form, I would like to have a calc field that returns the email of the same person the email is found in the table and field xfco_specialists___email
How would I do this please, I don't want them to have to select the email from another dropdown, I want them to choose the person, then the next field just populates the email address for that person but grabs the data from the other table.
Thanks