Creating a form showing the records of a table linked w/ a many-to

[iotuus]

Hi to everybody,

I have the following (simplified) situation:

I have a table called "Movies" and another one called "Actors"

The table "Movies" has the following attributes:
- Id
- Name

The table "Actors" has the following attributes:
- Id
- Name

As the relationship between them is a "many-to-many", I've created another
table "MoviesActors" with the following attributes:
- MovieId
- ActorId

Now I've related these 3 tables with two "one-to-many" relationships.

What I want now is to create a form showing the following:
- Name (of the movie I want to insert)
- Actors (that would be a control showing all the actors name that I have in
the table "Actors")

When the user would introduce the movie's name and select all the actors
that played in the movie, I want Access to insert one new record in the
"Movies" table and as many records as actors were selected in the
"MoviesActors" table inserting the movie id and all the actors id that were
selected.

Did I explain myself clearly? If you have any question please let me know
and thanks a lot for the help !

Bye.
Iotuus !