Search results

Thats what i was thinking, this is just a personal thing and i dont have more than 300 movies so i might leave the genre out. Thanks for the help, i think if i ever change my mind i would know what to do now.

OK thanks thats what i thought. I can do that on a form okay, but dont know how to put it into a report so a movie can be displayed under each one of its genres. Like this: movie 1: action, thriller movie 2: drama, action movie 3: drama, thriller Drama: movie 2 movie 3 Action: movie 1 movie...

Can you please give me an example on how to actually lay the database out. Would i need a joining table inbetween the genre and movie tables?

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...