Dependent query on table filters.
I am trying to filter table data and create a form to filter, It is working fine as expected.But now I have an requirement where the filter dropdown list is dependent on the other filter field value. How can I query based on the form field data is changed? I have attached the gif image for better visualization of the requirement.
For eg:
Once the first field is change now I want to query the server and get only those data related to field one and show in select dropdown menu.
For eg:
Once the first field is change now I want to query the server and get only those data related to field one and show in select dropdown menu.
