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 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.