I am creating a database on movies, with their CD colour and genre. Everything went well untill i came to the genre and realised that each movie had more than 1 genre. eg, action AND drama.
What i want in the end is a report that is grouped by the genre and under each genre heading lists all...