Thread

A client is planning a site with business listings. I thought EE2 would be a suitable choice for their CMS.

The business listings will be in a channel with typical business contact details like name, address, suburb, state and postcode.

I’d like to display these listings in various ways. For example, by city, by region (within a city) and by suburb.

How can I do this? Do I create channels for City, Region and Suburb and create relationships between them?

Is there a way to filter down the results as you drill down the hierarchy.  For example,  domain.com/city/region/suburb

EE Insider - “a primer on relationships with expressionengine” should help you out.

The article linked to from above describes using Playa, but has the native EE relationship option been removed?

When I read the User Guide on “Relating Entries”, Step One says we can set up relationships at the following place:
Admin > Channel Management > Custom Channel Fields

However, I don’t see any mention of relationships in any of the options under Channel Administration, or deeper down when I edit individual custom fields and the like. Please tell me I’m just missing something obvious!

Thanks,
Eric

It’s the top option in the “new/edit custom field” - the custom field type.

Thank you Lisa! I was looking for it in custom fields I had already created, and only discovered it when creating a NEW custom field. Thanks for the tip,

Eric

My pleasure, Eric! You should be able to change existing custom fields as well, now that you know where it is. =)

Another approach might be categories. 

I did a Client site that sounds very similar to what you are looking to build - business listings by state and category with drill-down nav.

I did a Train-ee post on the navigation.