displaying child values as text in parent report (instead of report link)

  • 0
  • 1
  • Question
  • Updated 10 months ago
I have three tables: Customers table is a parent to both Contacts table and Subscription table. 


Example: 
Customer Acme Inc. is subscribed to Subscription: A and B
Customer Acme Inc. has one contact: John Doe
Customer Widget Co. is subscribed to Subscription: B
Customer Widget Co. has two contacts: Jane Smith, Tom Harris 
Customer Parts Ltd. is subscribed to Subscription: A
Customer Parts Ltd. has three contacts: Jim Richards, Pete Thompson, Susan Edwards


I'd like to create a report that lists the contacts whose company (customer) is subscribed to A. In the example, the report would include 4 rows: John Doe, Jim Richards, Pete Thompson, Susan Edwards. 


Is this possible? 
Photo of AO

AO

  • 304 Points 250 badge 2x thumb

Posted 10 months ago

  • 0
  • 1

Be the first to post a reply!