Posted by crimsondryad on October 13, 2010 at 8:57pm
I have a site where I have a set of market area data. For example, OH-01 = Columbus w pop of 2million, OH-02 = Dayton pop = 1million, etc. I need to join that data in a view to other content.
I get how to set up the view. What I don't necessarily get is how to put the market area data into Drupal, and then turn it into a dropdown list as a selectable item on another content type. Would I have to make the market area a content type of its own? I want to be able to output this data in a table on a page and manipulate it in other ways, which is why I didn't want to just make it a CCK field.
I considered doing this via Taxonomy as well...but I'm not sure that's the right answer.
Anyone have suggestions?
Comments
Hope this helps
Since I'm not sure what you are trying to do with the data, take a look at http://drupal.org/project/hierarchical_select as a starting off point.
Good idea, but not really it
Or at least that's partway there...I do want to be able to select a market area from a dropdown in a content type for properties so I can sort them in a view by what market area they are in. But I also want to be able to use that market area data in a table so I can display it.
So I'm thinking, maybe I need a content type for market area that would include the following fields: market_name, market_id, population, couple more.
Then in a second content type called "properties" I want to use the market_name and market_id to be able to associate it market area to properties.
So basically, I want to join the data like you would in a DB.
UPDATE: Nevermind. I'm a retard. I just need to use a shared CCK field.