I'm building a church site, and I want to create a "media" channel with a list of all the messages. On the media index page there would be a list of images, some associated with a sermon series, others with just an individual message. When you click on one of the images for a sermon series, it would go to a list page of all the sermons within that series. I'm unsure of how to code the template and the channel entry fields to make this happen?
My initial thought was just put a field in the entry where they would enter the sermon series name, but that means they'd have to enter it in the same way each time for that series, otherwise the sermon wouldn't show up under the list of sermons. Then I thought maybe there could be a drop down menu with the sermon series name in it, and the admin would just select that. Then I imagined 5 years down the road when there are hundreds of items in a drop-down menu...that's obviously not ideal.
Does anyone have any ideas on an effective way to do this? Any input you can provide would be greatly appreciated.