AnsweredAssumed Answered

Complex many-to-many reporting question

Question asked by DavidLake on Mar 31, 2014
Latest reply on Mar 31, 2014 by DavidLake


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.