To include additional tables in the query:

  1. In the form where you want to apply an advanced filter, press CTRL+F3 to open the dialog box.

  2. Right-click the table name in the section.

  3. From the drop-down list, choose a table to include in the query.

Note Note

All tables in the drop-down list either have a one to many ( 1:n) or a many to one ( n:1) relationship with the selected table.

In a 1:nrelationship, each field in the selected table have one or more related records in the other table.

In an n:1relationship, one or more fields in the selected table are related to the other table.

Example

You want to find a line in a Sales order that has an important note attached, but you have forgotten both the order number and customer name.

You decide to print the report, using advanced query options, but when you try to specify the query range, you realize that there is no field in the table related to document references. You must add an additional table to your query.

  1. In the section, right-click the table, point to 1:n, and then select the table .

  2. Select the tab, select the table, Select Typein the list, and then select Notein the list.

When you run the report, you only get the order lines with notes attached and can select the one you were looking for.