Lookup based on Form Input

[Vandesm14]

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)

[Pete]

Hi there – it sounds like the New Members table might be better as a view on your members table. Mind reviewing this support article and letting me know if this seems like a solution?