Forum Discussion
Create 1 main view with 4 lists
Hello,
I created a 1:n relationship in Sharepoint. (primary key + foreign key)
as followed:
The ID of list "1" is used as a foreign key in list "2" & "3" & "4"
I have 4 lists and with them I creat...
aleyna6060
i would create a new SitePage and add all 4 lists as seperate webparts to that page.
Then i would connect die Webparts for lists 2,3 and 4 with list 1 on the lookup field.
The effect will be that if you select a list entry in the list 1 webpart the other webparts will automatically filter to all items related to the list entry in list 1.
Kind of like a dashboard.
https://support.microsoft.com/en-us/office/connect-web-parts-in-sharepoint-b457668c-d843-4b1b-8977-a6f9228a1dec