Show TOC

Procedure documentationSelecting Tables for the Query Locate this document in the navigation structure

Procedure

  1. In the Title field of the Table area, press the Tab key.

    The Choose from List window opens displaying a list of all tables in SAP Business One.

  2. Double-click a table to select it.

    The selected table is entered to the Tables area.

  3. In order to select additional tables, choose the Title field in the Tables area and press the Tab key.

  4. After you have selected a table, you can select tables which are related to it. Do so by dragging the related table name from the Fields area to the Tables area.

    When you select a table, its fields are instantly displayed in the Fields area. If the selected table includes a field that relates it to another table, this field is displayed in bold. Dragging this field to the Tables area adds the related table to the list of selected tables.