We have a SharePoint online communication site, and it contains these 3 custom lists:
Child-1 List which contain a lookup column to the Master list
Child-2 List which contain a lookup column to the Master list.
Now we are trying to achieve the following:
- When the user select/click on a Master list's item inside the build-in list view >> to show the following screen, which have 3 tabs; Master,Child-1 & Child-2, as follow:
When you click on each tab the related list item/s should be shown (the master should be the list item the user clicks on + the Child-1 & Child-2 should be retrieved based on the lookup field).
So is this something we can achieve in SharePoint online? and how?