Discussions

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

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

     
    Posted 02-26-2018 14:59
    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?