In this short video we'll examine table relationships in a number of different Access applications including the classic Northwind database. Proper table relationships are foundational to data accuracy and peak database performance. We'll define how one-to-many relationships work with the primary key field and foreign key field, discuss one-to-one relationships, and also show how to create many-to-many relationships using junction tables. We'll also examine Lookup tables, and how they help define and constrain values for a field.
All of my YouTubes can be found at: https://learncs.w3spaces.com/
Thanks, Lisa Friedrichsen