I use this query as the record source for a subform. I open the form from a dashboard button that first prompts for a program name to filter the list by. The ProgramName parameter is
Code: Select all
[Forms]![frmSeriesParameter]![cmbSeries]
Here’s the SQL:
Code: Select all
SELECT Viewings.DateWatched, Programs.ProgramName, Episodes.EpisodeName, Episodes.Season, Episodes.Episode, Viewings.SourceID
FROM Programs INNER JOIN (Sources INNER JOIN (Episodes INNER JOIN Viewings ON Episodes.EpisodeID = Viewings.EpisodeID) ON Sources.SourceID = Viewings.SourceID) ON Programs.TitleID = Viewings.TitleID
WHERE (((Programs.ProgramName)=[Forms]![frmSeriesParameter]![cmbSeries]))
ORDER BY Viewings.DateWatched, Programs.ProgramName, Episodes.EpisodeName, Episodes.Season, Episodes.Episode;
Thanks,
- Jeff