Description: This tutorial explains how to join two lists based on child parent relation without writing any code.
This post explains how to implement the child parent relationship between two lists/tables. Two lists will have one common field ID from Category list. Category.ID will act as primary key in Category list and will be used in Products list as a foreign key to match the items. Below diagram illustrate the relationship that has been implemented in the video.
Child Parent Relation