I am having a problem with generating a report. It has a section within the report that repeats itself. I understand that this is actually caused by the multiple fields within the table it pulls the data from.
However the reason I have multiple rows of fields in that table is because I had those fields provide the data to a query to input combo boxes on the form. After they select an option from the combo box, I would then need the information to show on the report without it repeating itself.
My guess would be that I'm not doing the combo boxes the way I should be doing them.
How could I still produce a combo-box with selections of different values, which would still show on a report but not cause it to repeat?
Here are some images to help show what I've done.
Table:
Form:
Query:
Report:
Thanks!