If you have a lot of tables, you may wish to group them. For example, an accounting application may have different modules, such as General Ledger, Accounts Payable, and Accounts Receivable. Rather than making the user select from hundreds of tables in the Step 2 of the report wizards, if you group your tables, they can select which data group they want to work with in Step 1, and then only see the tables in that group in Step 2 (they can also choose to see all tables).

A table can belong to more than one data group. For example, the Customers table in an accounting system might belong to the Accounts Receivable data group, but also the Order Entry data group. Place a table in as many data groups as makes sense for your users.

Data groups can also be used for security purposes; the Security dialog (available from the Tools menu in Stonefield Query) allows an administrator to restrict access to certain data groups on a role-by-role basis.

The phrase "data group" can be replaced with one that is more meaningful to your users if you wish, such as "module." See the Multi-Language Support topic for information on how to do that.

Before you can select which data groups a table belongs to, you have to define some. To do so, choose the Create Data Group function from the Objects or shortcut menus or from the drop-down menu of the Create button. You can also click the Create button when the Data Groups panel is selected.

After creating a data group, enter the name for the group. Since these names are only used internally in Stonefield Query and not for queries against the database, you don't have to worry about delimiters for names containing spaces or other characters. You are not allowed to leave the name blank or enter a duplicate name.

You can select the tables that belong to a data group by either turning on the checkmarks in front of the appropriate tables when the data group is selected or selecting a particular table and indicating which data groups it belongs to. Turning on or off the checkmark for a database turns on or off the checkmark for all tables in that database.

You can define the default data group for new reports if you wish. When the user creates a report, that data group is selected by default in the report wizards.

You can define the default table for a data group. When the user selects the data group in Step 1 of a report wizard, the table you specify in the Default table setting is automatically selected for a new report in Step 2.