Help

Add Field to Main Table if Record on Other Table

800 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Roy_Tucker
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
Zollie
10 - Mercury
10 - Mercury

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.