Opening tables

The same table can be opened in different views:

1) Standard table view

Standard table view allows viewing and editing data. This is main mode of operating with data in tables.

Fields (columns) can be groupped, filtered and ordered.

If you use Representation settings for the table, it is possible to specify name and description of the field. Name will be showed in header of column, description will be showed as a hint when cursor is pointed on header of the column. Several columns can be joined to one header. For example, for persons in business trips it can be Arrival information: flight, date and time of arrival, airport; Departure information: flight, date and time of departure, aiport.

2) Tree view

If table includes _id and _parentID fields, the table can be showed as tree table.

_id field is surrogate Primary key field, type is uniqueidentifier. _parentID is foreign key referring to the table itself, type is uniqueidentifier. This pair of fields make tree structure of the table.

3) Pivot view

Table is represented as pivot, the similar like it is represented in Excel. This representation is not based on OLAP-cubes that use MS Analysis Services.

4) Chart and Diagram view

Table is represented as a diagram or a chart.