Forum Discussion

cphite's avatar
cphite
Icon for Helper I rankHelper I
1 year ago
Solved

Select through multiple tables

I have three tables - Campaigns, Leads, and Opportunities.     Campaign can have one or more Leads, and each Lead can have one or more Opportunities.   What I want to do is have the Campaigns tab...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi cphite ,

    Thanks for amitchandak's reply!
    And cphite , This sounds like a problem with the interaction between visual objects. You can refer to the following steps:
    Click the Leads table, click Format > Edit interactions:

    Cancel the interaction between the Leads table and the Campaigns table:


    Then click the Opportunities table, and cancel the interaction between the Opportunities table, the Campaigns table and the Leads table:


    And the final output:
    Click Campaigns:

    Click on the Leads table while holding down the “Ctrl” key :

    If I only click Leads, The Campaigns table will not be affected:

    If I only click Opportunities, nothing will be affected:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.