How To Create One-to-Many Relationship in MS Access
In this video, let's look at how to create a one-to-many relationship between two tables in MS Access. It is a common scenario for shopping cart applications to have a Customer table and an Orders table. One customer can have many orders but an order can only be tied to a single customer.
Then, let's go over some of the relationship options like enforcing referential integrity, cascade updates and cascade deletions.