How to create a report, that dynamically merges data from two forms?
Hi,
I have 2 forms:
1) Customer Contacts (Company Name, Email Address)
2) Customer Purchase History (Company Name, SKU)
I want to generate reports dynamically so I can look up a particular SKU (from Form 2), and then a custom report will be generated containing a list of all the Company Names and Email Addresses (from Form 1), that have purchased the defined SKU.
How can this be achieved?