Grouping and creating relationships between standard tables can have significant benefits. There are several methods to group and relate tables: table groups, table relationships, and virtual tables. Table groups create a logical grouping of tables and are solely used for maintenance and security purposes. Table relationships allow data stored in several tables to be accessed by the Report Writer. Virtual tables build upon the idea of relating tables. Virtual tables allow data that is stored in separate tables to be read as if it has been stored in a single table.
Information about virtual tables is divided into the following sections: