Relationships. Relational Database. In the previous tutorial you learnt about identifying entities in a flat file database. Also its limitations and why a relational database is better avoids data redundancy and anomalies/orphaned data .
Under Database Tools in Access, Add both tables and create a 1 to M relationship between the Primary key in Sales Rep to the Foreign key in Jobs.
Tip - you should drag from the M to the 1 or the foreign key to the primary key.
Tip – close tables before trying to create the relationship.