How to select many items of a table(?) and link them to another table?

[Luru]

Hey, I'm new to Access and databases and I really need your help.
For example you know how movies can have many genres at the same time? Like drama, horror, comedy, action... So I make a table with all the basic information about a movie and then what? Do I make another table Genre and somehow list all the genres there and then refer to it somehow? And how do I make it so that I can select many genres for one movie? AND this is important, how do I make it with Access? I use Access 2010.



I hope you understand what I mean The problem is very clear in my head but because English ain't my first language I don't know if I expressed myself clearly Any Finns here???

Thanks!

[orange]

Here is a data model that may help with tables involved in a "collection" where there may be one or more genres per "item".

This sample is from a CD collection, but replace CD with movie and I think you have a model of the things that may be involved in your database. This is a sample, your application may not have all features.

http://www.databaseanswers.org/data_...zign_model.htm