Announcements
Hi All,
I am trying to build a app for Project Review where I have two SharePoint lists with nothing in common. I have a Project review master where there are three columns (Project Phase, Check item, Diagnostic Area each columns has 40 plus rows which gets updated for each project. For these 40 rows I need each two values(status, Observation) to be updated manually by the user). This gets updated every week. In order to reduce the increasing no of rows I created a second list called Project Review list with 40 columns (eg. PMC_status & PMC_Observation). I have attached a screenshot of how it look's like. when I combine two list with nothing in common it appears like the way in screenshot. Any ideas or suggestions on this how it can be done?
I would stick to the one original list and then have them enter it on a project-by-project basis - each of the 40 rows should have the same project ID right so that's your common field?
@iAm_ManCat
How come each of the rows will be having the same ID?
I assume you have a list of projects right? There's only one of each project in that list? Those are your unique IDs.
Then in the list with 40x per project, you have a field that refers to the ID of the project it is related to.
This is a basic pseudo-relationship (SharePoint isn't actually relational but we can pretend and create a similar function), you are relating each of the 40 rows to a single project row in another table
I have a masters list where these 40 plus rows are there. And in other list only I need to update the dropdown selected project and the other two values(Status and observation). So if I compare two list ID will not be common.
Ok, so this is more about data design then - as I said I would (if I was doing it) have a singular list instead of your two 40plus and status/observations
You have a parent list that is your list of projects, this list wouldn't grow as large
You have a child list that is the row items for each project, and it has a column that refers to the Parent list's ID, that way you can filter/relate them to each other and filter by projectID of the parent project.
@iAm_ManCat ,
I have a parent list which has these 40 plus row (this list has only three columns Project phase, diagnostic area, Check item) and this list doesn't grow beyond 40 because all the entries are unique.
The child list will have the Project name, and the rest of the 80 columns(why I created 80 columns because if I add for each project then the list would be full if some 20 projects gets updated in a week, so I created as columns). The child list will be having columns like which I shared the screenshot where for each project (one row) all the column will get updated. As you said If I need to compare ID for first time until I create a project how will I know the ID? Parent list I will be having ID till 40 but in parent list ID will b different for each project. How can it be compared? I hope you get an idea now.
Yes, I still understand - but what you're describing is that your 'master' list is actually the child list, since for each 40 unique rows, it will have the id of the project from the 'child list' which only has one row per project (so that is actually your parent list)
You should be organising your data differently if you want it to work the way you have asked - we can't imagine project id for a child item when creating the parent, that's just bad design.
Try something like this:
How the master list will be having an project ID because that list will not be having any project names. Only the three columns (Phase, check item, diagnostic area) will be there as I have attached the screenshot for the same above.
You need to change what you consider to be the parent list, as per diagram I shared, and you need a column to reference the parent item - you can't relate items that have no related fields without creating a related field of some kind.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 525 Most Valuable Professional
Haque 273
Kalathiya 232 Super User 2026 Season 1
