Using
Description
The Using keyword causes the report to use a dictionary other than the dictionary of the table being listed or selected.
Syntax
List table Using alt_table
Remarks
Using follows the table name in the report command. It is followed by the name of the table whose dictionary is to be substituted.
The Using keyword permits you to maintain one master dictionary for several tables. This is useful in situations where tables have identical layouts, such as master and history tables. The master table can have an associated dictionary, and the history table can simply refer to that dictionary when reports are generated ¾ no separate dictionary is required for the history table. This minimizes both maintenance and storage requirements.
Note: OpenList will always look first to the dictionary of table. If redirected with the Using keyword, OpenList will look into the alternate dictionary. In either case, however, OpenList will always also look in the dictionary of the MYTABLE table for column and keyword definitions. The dictionary of the MYTABLE table can thus serve as a global dictionary for all tables.
Example
The dictionary of the table INVOICES is substituted for the dictionary of the table INVOICES_HISTORY.
List INVOICES_HISTORY Using INVOICES