In this video we add the additional table called the Genre and again join it to ensure referential integrity. This time we use an auto number for the primary key - http://databasementor.com/basic-ms-access-lessons/basic-examples/cds-database/Auto-Number-In-Access/
