I imported those 3 tables from excel. Now, what I want to do is to have Genre on my MovieTable, which populated automatically. I try to link Movie_table and MovieGenre, however what is shown/populated in Movie table is only 1 GenreID. it takes only the top GenreID, while expectation that it should populate those 2 GenreID for the Movie
Am I missing something here?