AndrewOrner
8 years agoQrew Cadet
displaying child values as text in parent report (instead of report link)
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?
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?