I am trying to generate a report that simply shows me the sum quantity products sold.
Form Name: Order:
- Name
- Address
Subfom Name: Products:
- Product
- Quantity
How do I generate a pivot chart report that gets the data from the subform?
When I try to generate a report from the Order Data, I do not get the fields of the subform, and vica-versa.
How do I run a report of this data with relationship?
It seems the subform model is very broken because the relationship is inherently not there.