EE2 latest build.
I need help with figuring out the functionality of mixing channels, categories and relationships. Here is the setup.
Products Channel - All products are in here
Industries Channel - All indusries entries are in here
Applications Categories - (Area, Parking, etc…) All product channel entries are associated with applications
Industries Categories - (Office, Park, Auto) All product channel entries are associated with industries.
I currently use categories to display all industries (Category URL setting turned On) and then I can drill down into each industry that contains a channel entry. Once I’m in that channel entry I want to display “product entries” that are associated with that channel entry. I tried using relationships to do that but it only allows me to do a one to one relationship with an industry channel entry. One product entry could be used in many industry channel entries. So ideally I would like the relationship field in the product channel entry to allow me to pick mutiple industry entries. Is there a way to do that? Is there another approach I should be taking? Help would be greatly appreciated.