How to create Master Details View/Report based on 2 different lists

Hi @Mohammad Qasim ,

You could build connections between the master and details list. Please follow the below steps:

1. Create a page, insert the Master list and Details list to the page
2. Edit the Details list web part to build a connection to the master list. As the below picture shows:
3. Configure the connection settings. Provider Field name is from the Master list , Consumer Field name is from the Detail list.

Test result:

I have data like this

Solution Required: first it shows data where parent id =0 ( as a master record ) and when I click on master record so it should bring its all child,grand child and so on .( attached image is for reference ). It helps user's to sort out all its relevant record like

if user click on "ABC" which ID=4 and Parent id=0

so it should show records where id equals
5,6,7 and 8 ( not 9 and 10 because 9 is not its child ,itself its master record because its parent Id =0 )

Hi @Mohammad Qasim ,

Looks like your data are in the same list. If so, there are no OOB ways to achieve this.

You need to use some code to achieve this. Please refer to this similar issue:

https://video2.skills-academy.com/en-us/answers/questions/55065/dynamic-hierarchial-tree-view.html