We have a report that has a select box that contains a very long list of stores. Each store has a very long list of their own product IDs.
When I select a store from the select list the product IDs list populates so that I can select one or more products. That works great.
However, when I select multiple stores, the product IDs list grows extremely long making it difficult to find the IDs the user wants to select.
Any ideas on what a good solution is to this? Is there maybe some way to make it so that the last store that is clicked on then only that store's product ID's display in the select list?