I'm designing a site with user created content of types Story and Story Chapter. I'm trying to have a link to the next chapter in a story on the page for viewing a chapter. Here's how I'm currently set up, and I can't think of a good way to do what I want:
Story and Story chapter have a relationship "is_chapter_of". The Story Chapter has a field for its chapter number. I've tried using a view with a contextual filter for the node id of the chapter, then using two view relationships to get all the chapters in a story using the "is_chapter_of" relationship on the Story Chapter. Then I'd like to filter based on (Other Chapters) Chapter Number equals (This chapter) Chapter Number + 1. As far as I can tell, views doesn't have a way to increment the value for a filter like this.
I don't want to use the book module because I've found that users can add chapters at multiple levels and I want to restrict the level to one.
Any suggestions are appreciated. If you have an idea that involves a restructuring of the data I'm open to that, just please describe specifically how you would structure the content types.