Add Field to Main Table if Record on Other Table

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.

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