Filter a table using value selected in a list and filtering another table using the filtered values
Hi All,
I have the following tables
Table 1
TenderIDProjectTitleOrganisation2024_1Title 1Organisation12024_2Title 2Organisation22024_3Title 3Organisation32024_4Title 4Organisation4
Table 2
TenderIDTataSailJSPL2024_1YesNoYes2024_2NoYesYes2024_3YesYesYes2024_4YesNoYes
I want to select one of Tata, Sail, JSPL from a List
1. Basis the value selected, I want all those TenderIDs where value in Tata column is “Yes”
2. The ultimate objective is to filter Table1 to show the values with above TenderIDs where value of option selected from the list is “Yes”
Hi All, I have the following tables Table 1TenderIDProjectTitleOrganisation2024_1Title 1Organisation12024_2Title 2Organisation22024_3Title 3Organisation32024_4Title 4Organisation4 Table 2TenderIDTataSailJSPL2024_1YesNoYes2024_2NoYesYes2024_3YesYesYes2024_4YesNoYes I want to select one of Tata, Sail, JSPL from a List1. Basis the value selected, I want all those TenderIDs where value in Tata column is “Yes”2. The ultimate objective is to filter Table1 to show the values with above TenderIDs where value of option selected from the list is “Yes” Read More
