Complex many-to-many reporting question
Here's my table structure (names have been changed to protect the innocent :-) and my report need:
Grocery Stores ----< Join >---- Cookies -----< ingredients
Cookies can be sold in multiple stores, stores can sell multiple kinds of cookies, each cookie has it's own list of ingredients.
I have the easy reports finished. Now I'd like one that summarizes in this order:
One summary line for each Store in the Join Table
One line for each cookie sold in each store
(now the trick) And the detailed list of ingredients for each cookie sold in the store.
The cookie list and the related ingredients needs to repeat for each store in which they are sold.