I have a scenario to handle, would really need help to sought this.
Below is the data from different column i have loaded.
Now both the LIST has project ids.
On selecting the highlighted project ID, there is no data in the Table, Because there are NO RESOURCES path of this project.
Selecting Project Id from second list , highlights 3 resources who have worked on the Project Id: 100010. I even get an information that there are one or more resources from the list who are currently in the project 100014.
TO make this more user friendly I want to Show PROJECT NAME linked to Project Id for selection from the SECOND LIST.
THIS WORKS, but vice-versa is not working, if I directly select PROJECT NAME from the LIST
Can I write expression in the LIST : to select the Project Name where the Project_ID is among the All_Project_Ids