Need to set criteria for subreport

PamelaJoy

Registered User.
Local time
Yesterday, 18:18
Joined
Oct 28, 2008
Messages
39
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!
 
In the subreport control on the main report (not the subreport object itself), set the following properties:
Link Master Fields: name of your container field in the main report Record Source or a textbox on main report with this information
Link Child Field: name of the container field in your subreport
 
That was a huge help, thanks - but I also had not linked the fields properly in the query. Going through the steps to link the Master/Child Fields I made the discovery! Thanks so much.
 

Users who are viewing this thread

Back
Top Bottom