10 Things You Need to Know About Relationships in Access 2013
A one-to-many relationship connects one record in the parent table to many records in the child table.
Set the relationship to connect orders to customers or doctors to patients. One customer can have many orders and one doctor can have many patients. This way, you don’t have to repeat all the customer contact information on each order nor all the doctor contact information on each patient.