The relationship between the video sites and the video distributors is also many to many. This is because one distributor can distribute to many video sites and one video site has sometimes more than one distributor. I therefore need a table in between and use lookup for the relevant fields. I then go to the relationships window to ensure referential integrity.
