Lookup based in form Input


#1

So I have a “Members” table with “Name” and “Email” as fields
I also have an Activity form for activity checks as “New Members” table.
They put in their email in, and submit the form. This is then placed in the “Email” field.

I want to display their name in the “Name” field of the “New Members” table using lookup. I know I can use the link to another record field, but that isn’t automatic. Is there a way to take the table’s “Email” and set a value to the “Name” field based on the email that was provided (executing a lookup to the “Members” table)