Hi, thanks for your answer. But I don't quite get it.. By laying genre as an FK in Film, what happens to the tables Genre and moviegenre?
Is there any possibilty in having three tables in one form?
One of the things that makes it hard for me to have genre in the film-table is that there are many genres per film.. This is why i thought a table for the genre would be a good idea, but I have no clue about this
I have problem picturing the last thing you said about; "then store the relevant FK for the selected Director and Genre"
One film can be classified into many genres. A movie can be both a horror and a comedy for example.
moviegenre would be the intersection table between the many to many relationship between Movie and Genre.
how i can type in all this information from the three tables Genre, director and film, in one form???
You can't and you can. You would need multiple forms - one mainform and at least one subform for your movie genres. In the end you will be able to see/manage the details for a DVD, including all the items you described.... on one SCREEN, but not one form.
Hi thanks for the answers.. Startrekker has right on the genrequestion... I start with the formwizard, then add movietable, director table and the genre table.... Thats were the problems start.. when I try to add information in the subform for genre, it would not let me.. so what do I do ? For example, I can add the movie Forrest Gump in the Film - table; year, name, length, publisher etc.. Then I can add Director information like; name, born, death etc... And then the problems start with the subform for Genre; all I want to have is the different genres per movie info in the form.. So I have tried adding both name and genreid, doesn't work and all I get is different error messages like; the info can't update etc... Any ideas?? Thanks for the answers poppa and startrekker
You stated "For example, I can add the movie Forrest Gump in the Film - table; year, name, length, publisher etc.. Then I can add Director information like; name, born, death etc... And then the problems start with the subform for Genre; all I want to have is the different genres per movie info in the form."
My question is WHY do you need to add the Director details as above for each entry? If you enter details for FILM_1 with the details entered for Director1, then you enter details for FILM_2 directed by Director_1 are you not duplicating the data for Director_1?
Hi! Thanks alot, I see the problem with duplication, but what are my alternatives? Because in your example database I have to insert director info and genre info separately, right? This means that I have a whole lot of work to do and basically doubled up the work with over 500 dvds to fill in... This is basically a big problem and the reason I want all info on one form without filling in info in different places..
I get the genreform, because this is not all that much work to enter new info about, but the director? How can I put in the other info about the director, and must I always type in info about the director before go to the form?
What do you mean by an input screen and how do I get it? (Ain't that used to the english version of access)
Sorry if I seem like a question mark on this..