Database records grouping

MyTaskHelper development team has created a new functionality for working with databases, namely the database grouping.

The grouping is used to combine records on the same basis (the field). For example, we have students' database in which we can find the names of students, universities in which they study and cars purchased by them. It is clear that students can buy different cars. The question: is it possible to combine records in the database so as to have an idea of what cars are owned by this or that students.

See step-by-step instructions below:

For using the grouping option open your project and go to the Records menu.

Click on the Grouping link. In a new window you should select fields for grouping and specify how to display records (ascending or descending). Groups priority is defined by fields sequences in the window (top to bottom). To change the fields location move them to the desired position with the help of the mouse.

See your database after grouping. The result is students are combined according to the University they study.

In MyTaskHelper databases you can use Grouping by multiple fields. It's very easy. Slect several fields in order to do it.

Grouping result: we can see students who have the same cars and study at the same university.

Also using the grouping option you can change fields (columns) sequence in the table. For this you just need a mouse to set all the fields in the correct sequence. See the screenshot.

As a result, we changed the fields (columns) sequence.

24.08.2010 Igor Petrushenko