Forum Discussion

KevinGullickson's avatar
KevinGullickson
Qrew Trainee
4 years ago

Embedded Report Based on a Third Table

I have a table (Partners) with two child tables: (Ads) and (Publications).  A Partner can be both an Advertising Partner (Ads table) and a Publication Partner (Publications table). (Publications) is also a parent of the (Ads) table, so an Ad also has a Publication Partner.  I want to embed a report within a Partner record when they are the related Advertising Partner.  Easy...I got that!  But I also want to embed a report on the Partner record when the Partner is the Publication Partner (not necessarily the Related Advertising Partner) on the Ads table.  I'm stumped on how I would go about that and would appreciate any tips there.

Thanks!

------------------------------
Kevin BP
------------------------------
Relationships
reports and charts

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    np,
    You do not need to have a relationship to use a Report link field.

    Lookup the field for [Related Partner] from Pubs down to Ads.  Re-name the lookup field what it is - which is [Record ID# of Partner].

    Then, just create a new report link field on Partners.

    Configure the left field as [Record ID#]
    Configure the right field as [Record ID# of Partner]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------