The standard method of creating a many-to-many join is to create what is known as a
junction table.
Based on what you have provided above (Table: Event & Table: Home) you would create a third table - normally named
Event__Home that consists of the following columns;
a) Primary Key
b) Foreign Key to Event table
c) Foreign Key to the Home table
When you add a new reference between Event & Home a new record is created in the Event__Home table that comprises of the Event Id & the Home Id.
The Models for Event & Home should be then updated to include collections from the Event__Home table.
MVC will allow you to traverse these to display additional values from the relevant table.
The below article will give you additional information on Many-to-Many joins etc;
MSDN: How-To: Many to Many Relationships[
^]
Kind Regards