Linking Table(A) to Table(B) using Primary Field or a different "lookup" field?

I’m wondering if this scenario is possible - I cant seem to figure it out…

Table(A) includes generic contact data: Email(Primary), Name, Phone#, Address, etc.
Table(B) captures an event as a record.

The use case I’m hoping to figure out is how to link Table(A) into Table(B) by populating either the Email OR Name. I’m familiar with the Lookup field, however, my understanding is that it can only be populated via field data pulled by the Primary Link(Email).

I tried creating a 3rd table to link Name to Email but was ultimately unsuccessful in getting Table(A) to capture the record in Table(B).

Any advice/suggestions?

Thanks in advance.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.