Hi, i designed a form with a filter where I can filter all entries in the grid. It is the same as it works for example in the CRM smmBusRelTable for the employee.
My filter works fine. But now I just want to see one dataset for each combination of the filtered field and another field in the table. For example: My table CustId ItemId Value1 Value2 111111 22222 v111 v211 111111 aaaaa v222 v222 111111 22222 v333 v233 111111 BBBBB v444 v244 777777 22222 v333 v233 111111 22222 v333 v233 When I filter for CustId '111111' I only want to see --> one dataset with the combination of CustId and ItemId. The 3rd and last row will not be displayed, because they have the same combination of CustId and ItemId. I like to get this Table: CustId ItemId 111111 22222 111111 aaaaa 111111 BBBBB Something like "group by". Is there a possibility to manipulate returned datasets of the query. Has anybody an idea? Thanks and greets joerg
