Hello,
I have a form where I am displaying employees according to their department where some departments have sub departments. My issue is with the group by feature on the department. I grouped the Department column then saved it as a view. This maintains the grouping each time the form is opened where the department is initially set to ''Client Services'. However, if I select a department after the form is initialized, then the grouping is undone as Im executing the query again to display Employees according to the selected department. How can I maintain the grouping each time the query data source is executed? Thank you
E.g. form is initialized below and loads the saved view grouped by department
After I select another department, the grouping is gone.
