Here's a video on how to create One-to-Many relationships between two tables in Microsoft's Access; where you can have basically relate one record to many like one customer that has many orders.
30th Sep 2017
Access 2016 training video on how to create a One-to-Many relationship between two tables, where you can have basically one record linked to many other records like: one customer that has many orders. This also includes enforcing referential integrity, cascade updates to related fields and deleting related records. …
26th Sep 2017