I have a report showing the ingredients in each finished product with associated costs, weight, etc. Now I need to bring in the containers -each finished product has from one to four container possibilities. Everything I've tried (subreports, queries, etc.) lists every single container, either after each and every ingredient (instead of for every product) or as a huge list at the end of the report.
How can I get my subreport to 'see' the container type on the main form and match it to only those containers with matching container types?
I am making myself crazy!
How can I get my subreport to 'see' the container type on the main form and match it to only those containers with matching container types?
I am making myself crazy!