We're building a wine site, and the association between wines, producers and regions is causing trouble for us.
Here is the problem:
We have three different section editors: Wines, Producers and Regions.
When creating a wine we want to be able to associate the wine to a producer, and also associate the wine to a region. At the same time, we want to be able to assign a producer to a region.
With this logic in mind, is it possible to display a list of producers by region?
Ex. Producers in Italy
- Producer Name 1
- Producer Name 2, etc..
And then, by clicking on the producer, you are brought to that producer's details page.
Is this possible? Is this clear? Can someone help?
Finally, can one category list link to another category list OR can a category list only link to a multi-list?
Thanks a lot.