I need hel with a query for many to many relations

[taukafsha]

Hello guys i'm having some problems with my query , i have to make a db for movie collection and i made a query that shows the filmID, FilmName, ProducentName, ActorName, but what i want to do is the qyery that shows all actors that plays in one film , i have related the actorId to the actorId in Film Table and i added manyally all the id's of actors in child table of one film in film table. So i made a queri that ask for the type of movie and i input hte value but that shows me only 1 actor in the field actor name, only the first actor id listed in the child table in flm table, i want to show all of them that plays in a movie.

[orange]

Please show us your tables and relationships.

For dealing with Many to Many see
https://www.youtube.com/watch?v=7XstSSyG8fw