The “Edit All” function does not work properly in the Sub Contract Revisions and Items Screen

When creating a subcontract, we can assign the sub contract to certain projects.

The revisions and items are then linked to the Activities available in the project. There are subcontracts with sometimes 100 items, where “Edit All” functionality is used on a column field to assign the Project, Sub Project, Activity to the items in the Revisions and Items.
The issue is, when selecting “Edit All” we can see all the projects in the system. However, it would be better to only see the Projects assigned to the Sub Contract, on the Sub Contract Header.
This issue also concerns the columns “Sub Project” and “Activity”.

Steps:

1. On the Sub Contract header details, add the Project
2. Go to the Revisions and Items
3. Edit the Items - on column “Project” click on “Edit All”
4. In the dropdown list of the “Edit All” screen, all projects are shown. The suggested expectation is to only see the Project that is assigned in step 1 (Sub Contract header).
5. The same issue is also seen on the column “Sub Project” and “Activity”. Here the issue is even bigger as the only the Sub Project ID/ Activity ID is shown in the list, and the Project ID is not visible.

Please analyze and improve the functionality of the Edit All functionality.

This is an issue since it is error prone and user can easily make mistakes.