In a many-to-many relationship between two tables, one record in either table can relate to many records in the other table. To establish a many-to-many relationship, you need to create a third (junction) table and add the primary key fields from each of the other two tables to this table.