Skip to main content

Add Field to Main Table if Record on Other Table

  • February 3, 2020
  • 1 reply
  • 18 views
R

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.

    This topic has been closed for replies.

    1 reply

    Z
    Forum|alt.badge.img+18
    • Zollie
    • Inspiring
    • February 4, 2020

    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.

    Terms & ConditionsAccessibility statement