Okay, so i already have a SS site up and running. It's ideal for a rather basic website but...

Now i want to take it to the next step and i'm totally lost. I've been playing with Tutorial 5 and it works great but it's to complex for what i want and i don't know how to 'rip' it. I've been playing with ModelAdmin as well but i guess i could use some more documentation on that.

Here's what i want. A TVserie database.

- A serie has Several seasons (1-to many ?)
- A Season has several episodes (1 - to many ?)
- An episode has 1 serie and 1 season ( or is this not nessasary?)

So i want to select a serie -> go to the seriepage -> choose the season -> get a list of episodes

I did make the seriepage ,seasonpage and episodepage resulting in 3 tables

class SerieAdmin extends ModelAdmin {   

public static $managed_models = array(
   'Serie',
   'Season',
      'Episode',
);

static $url_segment = 'series';
static $menu_title = 'My Serie Admin';

}
class Serie extends DataObject {   
static $db = array(
   'Title' => 'Varchar'    
   );
   
    static $has_many = array(      
      'Seasons' => 'Season',
      );

}

class Season extends DataObject {   

   static $has_one = array(
   'Serie' => 'Serie'          
   );
   static $has_many = array(
      'Episodes' => 'Episode'
   );

   static $db = array(
   'Name' => 'Varchar',
   );

}

class Episode extends DataObject {

static $has_one = array(
   'Season' => 'Season'
    );

   static $db = array(
   'Name' => 'Varchar'
);
   
}
-----------

But now i'm totally lost, where to go now to display it all the way i want.???

I made a TVSerieHolder, and ChildrenPages 'TVSerie'.
So now when i create a TVSerie page for every Serie i can actually navigate to the corresponding Seriepage (well after all that's the whole point of having a CMS, right?).

But how do i tell this page to only show the corresponding Episodes? Because now it shows all Episodes
( function EpisodeList(){return DataObject::get('Episode'); } ) How do i use some kind of filtering?

This is what i want;

eg;
X-Files ---go to the X-Files Pages (Works)
IF (X-Files has more than one Season)
Show Seasons (Then let me choose which season i want to see the episodes for)
ELSE (show all Season 01 Episodes)

I think i need to use something with $this but i can't figure it out.