Types of Table Relationships in MS Access:
One – to – one relationship
The primary record will have only one related record.
One – to – Many relationships
The primary record may have many related records
Many– to – Many relationships
Many records from one table can be related to many records from another table through a junction table.
