We have more than 1500 materials in our system, and now for specific reporting purpose we need to grouping the materials in different groups
While query design we try to do the characterstic groupings by using the structure.
But problem is that there are more than 1500 materials and need to group as more 100groups. manually grouping this materials is very time consuming and also after creating the query like this ,it will take too much time to open it(my opinion).
Is ther any way simple way to achieve this(grouping many material into many groups)?????
Please suggest me , maximum points will be awarded.....