common Projects name with different Part no.

Hello,

Please revert with solution

Illustrating this requirement with an example for better understanding –

Case 1-

If the user selects “P82012, P82013, P82014, P82015” then Project 1 and Project 2 should be displayed.

Case 2-

If the user selects “P82013, P82014” then all the projects should be displayed.

Case 3-

Check the feasibility and design for implementing this use case -> If the user selects “P82012, P82013, P82014, P82016” show the projects which have at least 3 Parts in common. i.e., Project 1 and Project 2. “3 Parts” can be a variable which user can select the number of common parts, maximum being 10.

Case 4 – Vice-versa of the selections in Case1 and Case 2. i.e., User selects more than one project to get the list of common parts used in them.

Case 5 – Vice-versa of Case 3 based on feasibility and effort involved..