Okay so I have looked at How to create a complex stockist list using Structure and/or categories and have studied all of the comments carefully but I don't think any of those setups are going to work for me. Although I'm open to any ideas on how to implement those into what I'm doing.
Okay here's my scenario and setup:
- Businesses Channel
- State and City Channels as sub-pages with Structure
I have a matrix field setup for each individual business with Playa fields pulling in the State and City.
I have a small set of Categories associated with each individual Business.
What I would like to do is to have a list of States on a Business page (I currently have this setup which pulls a list of each State in the "State" channel". that clicks through to the list of City's under each State.
I figured I would need a relationship (Playa) for each City, so EE knows which State each belongs too. I have this portion setup too.
WHERE MY PROBLEM LIES
I'm not sure how I am going to pull in (for example) Bob's Towing company in Boulder, CO on the business page.
I think using Playa is the way to go, but I'm currently lost at the moment on how to bring it all together. I want to avoid having to setup more Structure pages under each and every City as this will quickly become quite the mess.
I am open to virtually anything.
WHAT I'M GOING FOR
- Business Page
- Listings of States on Business Page
- Listings of Cities from the States page, making it easy for people to find what they are looking for
- Have a list of Categories clicked from the States page with individual businesses organized accordingly.
I am certain there's a better way of doing this and am looking to the EE gods for help on this. I am open to setting up a Channel for each State if need be, but again I'm looking for some better suggestions.
Thanks again for reading this and offering any advice on how I can bring all of this together!
Cheers