You can define drill-down levels from separate database tables if more than one table is included in the filter string.
Define your filter (consult the Acquiring Filters topic for details). A filter with two database tables is displayed in the example below. As you can see, this filter uses both the WKORDER and WKWOTSK tables.
In the Drill Down dialog, the drill dropdown lists will contain all tables included in the filter string. For our example, the dropdown lists contain both the WKWOTSK and WKORDER tables.
Select a database table from the first dropdown list.
Select a column name from the second dropdown list. The columns in each list are limited to those included in the selected table.
Click OK when you are finished defining your data drill.
Important: Filters that contain an inner join may not work as expected.
