Hello everyone, I am using Access 2013. A few years ago, I created a many-to-many movie database. I've never been great at database design, and I got a LOT of help from several people here. (Thank you.) In fact, I did not know what a junction table was until I got responses here.
Anyway, I need a little bit more help with the database. I'm attaching a copy of the database to this message. It has three continuous subforms, one for actors, one for directors, and one for genre.
Here's what I want to do: I want to generate a report that lists all the movies by a specific director, or a report that lists all the movies with a specific actor. I'm having trouble figuring out how to do this.
Is the best way to do this by creating a query, and then generating a report based on that query? If so, I haven't figured out how to do that. Is there a SQL sequence that would make this possible?
Movie Database 2017.zip
Thank you very much for any assistance. J. Danniel