Create Master Detail View of Custom Lists using WebPart Connections

 

Sometimes you want to have to lists, if you click on a record in the one list (e.g. name), you want details about that record (e.g. hollidays from that specific person). One of the options is to use Out of the Box WebPart Connections in SharePoint to realize this.
First I created two custom lists with the follow coloumns:
Custom List: Employees

Custom List: Holliday

1. Next step is to pass this to lists on a webpart page. With the employee list webpart on top.
2. Select Modify Shared WebPart (of the employeelist webpart) > WebPart Connections > Provide Row To > Holliday

In the next screen choose "Last Name"

Now you can select a row from the top (employee) tabel you get details in the bottom (holliday) table