Crow Canyon Software Forum
Many to Many..Sharepoint Lists
Quote from skigeek on November 15, 2022, 5:08 pmI have 2 lists...
- Staff Members and profile
- Projects
The quandary that I have is that Each staff member can be working on many projects.. But I would also like to go to the project and see all the staff that are assigned to it. I can create a parent child relationship one way and it works, But cannot figure how to make it go both ways. I do not have access to a real database so only using Sharepoint lists.. Not sure if this is possible. Any help or direction would be appreciated.. I know with a real database I would also create a linking table that would contain my many to many.
I have 2 lists...
- Staff Members and profile
- Projects
The quandary that I have is that Each staff member can be working on many projects.. But I would also like to go to the project and see all the staff that are assigned to it. I can create a parent child relationship one way and it works, But cannot figure how to make it go both ways. I do not have access to a real database so only using Sharepoint lists.. Not sure if this is possible. Any help or direction would be appreciated.. I know with a real database I would also create a linking table that would contain my many to many.
Quote from ACR-SCOUT on November 16, 2022, 9:24 amIf you are using Nitro apps then in your Staff Member list, add an associated item control to the display form. Wire it up to Projects list. This will show all assigned project to that staff member. This assumes that in the projects list you have a nitro lookup column to the staff members.
Likewise, in the projects list add an associated item control to the display item form. Wire it up to the Staff Members list. This will show all staff members on each project. This assumes you have a nitro lookup column in the project list to the staff members.
If you are using Nitro apps then in your Staff Member list, add an associated item control to the display form. Wire it up to Projects list. This will show all assigned project to that staff member. This assumes that in the projects list you have a nitro lookup column to the staff members.
Likewise, in the projects list add an associated item control to the display item form. Wire it up to the Staff Members list. This will show all staff members on each project. This assumes you have a nitro lookup column in the project list to the staff members.