I have a form with two different subforms inside. The subforms have multiple selections.
I would like to create a report that has the fields of the main form and all the selections from the subform as 1 entry on the report. Is this possible?
Right now, when I make the report, it shows each subform selection as a separate entry on the report.
What I would like to do is this:
The main form has 1 company field. And the subform could have unlimited selections of items. I would like the report to show 1 company with all the sumform selections in 1 entry only. Right now it duplicates the company field for as many as there are subform selections.