Skip to main content
Question

Embedded Report Based on a Third Table

  • April 1, 2021
  • 0 replies
  • 27 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement