Microsoft Access A to Z: More on primary and foreign key fields and indexes
This short video reviews the need for a two-field primary key field, the role of foreign key fields, and how indexes are used to improve the integrity and performance of your database.
It features the Order Details table from the Northwind database which uses a two-field primary key field. The Order Details table serves as a junction table with one-to-many relationships back to the Products and Orders tables which have a many-to-many relationship.
All of my YouTubes can be found at: https://learncs.w3spaces.com/
Thanks, Lisa Friedrichsen
