I am creating a website for a weekly web-based radio program and have run into the limits of my knowledge of Drupal. I have created a content type called 'Episode' where I enter all the information and upload the audio file. But my friend will rebroadcast an Episode if it is popular or when he takes a week off. I have just assumed he would create a new Episode with the same content. Unfortunately, this creates duplicate entries when searching the site, and spreads comments and 'Star Ratings' across multiple nodes.
I would like to create a view or content type that refers to a single Episode multiple times by the actual broadcast date, as in this example from the current/old site. You can see the interview with Ian Holzman is repeated two weeks in a row, but clicking either interview takes one to the same content.
Do I have to create a new content type (e.g. 'Broadcast') that can contain this information plus the actual date it is broadcast? If so, how do I pull-in the information from the existing interview Episode?
Or do I need to add one or more specific modules to make this possible?
If I can learn how to do this, I think I can create the View necessary to create the same kind of table display.
Thanks in advance for any help you can provide!

Comments
You have the right idea -- content type plus nodereference
I think you're on the right track. The episode content type can stay as it is and will represent the actual episode -- audio file and any metadata about the audio itself. Then create a separate content type, "broadcast" makes sense. This content type would a date field but no audio file. It would record an broadcast instance of the "episode" an any metadata about this instance -- it could probably be as simple as the date and a description of the broadcast in the body field (i.e. "Repeated due to broadcaster's vacation.").
Then what you'll need to do is make a connection from the broadcast to the episode. The best way to do this is use a nodereference. You don't mention which version of Drupal you're building the site with but this can be done in D6 or D7. If you're using D7 I'd recommend using the Entity Reference module -- https://drupal.org/project/entityreference.
Basically (truncated details below see https://drupal.org/node/1327954 for more install documentation):
Now, when you add a Broadcast node you'll have a field that will show you all of your episodes (either by autocomplete or dropdown). You'll select the one you want and a reference between the 2 will be stored.
This will give you all the ingredients you need to take the next step which will be to create a view display that will find all the Broadcasts for an episode and display these in a block on the Episode. This is pretty straightforward. I think this documentation page -- https://drupal.org/node/1841004 -- provides a good overview of how to do this.
Summary:
based on the entity reference field you created
Basically what you're doing is making a view display for Episode page that will recognize node id of that Episode and find any Broadcast nodes that reference that node id (entity reference fields simply store the nid of the content you choose to reference). With this info and the "Relationship" you set up between the Episode and the Broadcast, you can display any data (fields) from the Broadcast on the Episode page via this view display block.
Okay, I know that's a lot to digest if this is new to you. But getting over this hump will set you up to do a ton of cool things on Drupal sites. Data referencing data and displaying referenced data is one of the reasons to use Drupal.
Good luck!
Barry Madore
Triplo
Minneapolis-St. Paul, MN
Just what I needed!
I cannot thank you enough for this information!
I will try it in the coming days.
Have a great weekend!
TV
Thanks and a follow up
Hi Barry,
Thanks so much for the thoughtful, detailed response! I have created the 'Broadcast' content type, but need a different sort of view that I don't know how to create.
On the current/old site, the radio programs are listed in a table view. Where you see the 'Air Date' I will be putting the 'Broadcast Date', but the idea is still the same.
I created 3 'Broadcasts', and tried to create a view listing them all, but it is not pulling in the data from the 'Episode' I want. What am I missing or not doing right? I suspect I have to add the additional fields, but how do I configure them so that selecting the correct 'Episode' will put in the correct data?
Thanks again for the boost I needed to get over the hump on this one!
TV
Different kind of view needed
Hi Barry,
Thanks so much for the thoughtful, detailed response! I have created the 'Broadcast' content type, but need a different sort of view that I don't know how to create.
On the current/old site, the radio programs are listed in a table view. Where you see the 'Air Date' I will be putting the 'Broadcast Date', but the idea is still the same.
I created 3 'Broadcasts', and tried to create a view listing them all, but it is not pulling in the data from the 'Episode' I want. What am I missing or not doing right? I suspect I have to add the additional fields, but how do I configure them so that selecting the correct 'Episode' will put in the correct data?
Thanks again for the boost I needed to get over the hump on this one!
TV
Use relationship on the fields
While I cannot see your view configuration itself, I think what you need to do is use the relationship you created from the previous tip. In the fields area of your view, click on "Edit" for the fields you are looking to display from the Episode content. At the top of the dialogue box you should see a dropdown that asks you if you want to use a relationship. In the dropdown, choose the relationship you created. If I'm thinking clearly and your view is set up the way I think it is, this will reach into the related Episode content for this field rather than into Broadcast content where the Title field is coming from. Be sure to leave the Title field not using the relationship.
(Sorry for the delay in responding -- I missed the notifications of your earlier comments...)
Barry Madore
Triplo
Minneapolis-St. Paul, MN