Insert genre of the movie and autmatically insert ID of genre

[MitjaHD]

Sorry I'm new to databases and Access but I will try to explain the problem. I have tables Movies and MovieGenres and in MovieGenres there are 5 generes with IDs and name of genre. I want to insert name of the genre in Movies form and then autmatically detec which ID this genre has, so I don't have to type it two times. Tables are connected with ID_genre (ID_zvrsti in my language).



Film = Movie
Zvrst = Genre

[CJ_London]

in a form for your Film table, use a combobox for the ID_zvrsti field with a rowsource of

SELECT ID_zvrsti, Ime_zvrsti
FROM ZVRST
ORDER BY Ime_zvrsti

then in the properties, column widths, enter 0 (which will hide the first column)