I have a grid that returns a large amount of records that I would like to create some drop downs that filter the contents of the grid, but the contents of the drop downs are based on what is visible in the grid. Kind of like the way Excel does a data filter.
Example:
Assume I have 5 columns, three of them are product, customer and vendor. When the grid is populated there are three dropdowns that list all of the visible products, customers and vendors respectively.
If you pick a customer, the vendor and product dropdowns should only show those relevant to the chosen customer.
If a vendor is then chosen, only those products that are within that vendor and customer are displayed in the dropdowns.
Does anyone have some suggestions/sample code as to how this can be accomplished?
Example:
Assume I have 5 columns, three of them are product, customer and vendor. When the grid is populated there are three dropdowns that list all of the visible products, customers and vendors respectively.
If you pick a customer, the vendor and product dropdowns should only show those relevant to the chosen customer.
If a vendor is then chosen, only those products that are within that vendor and customer are displayed in the dropdowns.
Does anyone have some suggestions/sample code as to how this can be accomplished?