Usability when linking from many to one record

[desuki]

Hi, Im new to airtable as I see it looks better than excel for doing table and database.
I have issue with linking table that has one-to-many relationship.

I have Movie Database with 3 tables; 1. Movie, 2. Genre and 3. MovieGenre.

• MovieGenre stores relationship of Movie and Genre. where 1 movie can have multiple Genre.
• The way I structure the table like below

1. Movie_Table
   MovieID | Title
   01 | Jurasic Park
   02 | Indiana Jones

2. Genre_table
   Genre_ID | Genre
   01 | Action
   02 | Adventure
   03 | Fantasy

3. MovieGenre Table
   MovieID | GenreID
   01 | 01
   01 | 03
   02 | 01
   02 | 02

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?