Skip to main content

I have three tables.



List A


List B


List C



All 3 lists have a common field (email address).



I want to have a field(s) on List A that denotes IF the email address is in List B and List C respectively.

I don’t know a solution as you’re describing it. But if your tables were setup like the below example, you could more easily search emails and the records they’re affiliated with.



List A


Email (linked record)



List B


Email (linked record)



List C


Email (linked record)



Emails


Email (email, first column)



The Emails table will have 3 additional fields, one for each table it’s linked to.


Reply