Assume that there are 4 tables, with association tables "between" each of them:
- Option Groups
Machines may serve many products, and a product may "belong to" many machines. Products have many Option Groups and an option group can belong to multiple products. The same relationship exists between Option Groups and Options.
Ideally, I'd like to return all of the data for a "menu" (there is not a menus table - that's just how I'm referring to a group of products that belong to a machine) in a single call, but I'm struggling to get things working right.
Any help, including a simple nudge in the right direction, would be very much appreciated!