In this Microsoft Access example we use auto number for the

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/