In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




Maintaining Drill Downs and Lookups
Browses display selected data in the form of a table. Two types of browses are available:
Look-up browses return the value you select to the active field in the calling program.
Drill-down browses are more complex. They include more information and can display, filter, graph, or print data.
The field values in the browse can come from a table or a view. A view is a table that has selected values from one table or several joined tables.
Use Drill Down/Lookup Maintenance (36.20.1) to assign drill downs or lookups to fields that do not have a browse, to replace a browse, or to delete one.
One of the most common uses of this program is to display generalized codes associated with a field. You can also assign look-ups to any field that acts as an index to a maintenance screen. You may, however, need to write your own custom browse to find and display the data.
Most programs attached to a function with Drill Down/Lookup Maintenance display values in a database table. But this is simply a convention. You can attach any Progress function to a field, and this program executes when the user selects Help. For example, you can attach the program calculat.p to field pt_avg_int to display a calculator.
Before you can use Drill-Down/Lookup Maintenance, you need to know:
The name of the field where you want the browse to display.
The name of the program using the field.
The program name of the browse to attach. If a lookup is missing for a particular field but exists for a similar one, use Lookup Browse (36.20.3) to determine the program that displays appropriate field values. Then use Drill Down/Lookup Maintenance to specify the same program for the similar field.
See Creating Browses for details on creating browses.
Determining the name of the program and field depends on the user interface.
In the Windows and character interfaces, run the program. Press Ctrl+Fand note the program and field names that display in the pop-up window.
In the Desktop interface, run the program. Click on the information button on the right side of the program title bar. The button is identified with the letter i. A screen displays program information, including the program name. To identify the field name, place your cursor over the field where you want to attach the browse. The field name displays.

Drill Down/Lookup Maintenance (36.20.1)
You can assign more than one drill down to the same field. A menu of drill downs appears when you request the drill down. Only one lookup can be attached to a given combination of field and program name.
You can attach browses to fields in any program, including another browse. Drill downs can be nested. A field can call a browse that can call another browse that can call another browse, and so on.
Follow these steps to use Drill Down/Lookup Maintenance to associate a drill down with a field or program:
1
Select Drill Down in the Drill Down/Lookup field.
2
Enter a field name to associate with the browse in Field Name. Leave it blank to associate it with all fields.
3
Enter the program containing the field in Calling Procedure. Leave it blank to attach the browse to all programs using the specified field.
4
Enter the browse name in Procedure to Execute.
5
Optionally, enter a label term in Description Term. The long label contained in this term is displayed as the title in the browse. The default is the browse description term defined in Browse Maintenance. See Creating Browses.
You can access drill downs in four ways:
Select Drill Down from the Help menu and click on the field.
Select the Drill Down icon on the toolbar and click on the field.
Double-click on the field in the browse.
Select the field and press Alt+F1.
Follow these steps to associate a lookup with a field:
1
Select Lookup in the Drill Down/Lookup field.
2
Enter a field name to associate with the browse in Field Name.
3
Enter the program containing the field in Calling Procedure. Leave it blank to attach the browse to all programs using the specified field.
4
Enter the browse name in Procedure to Execute.
5
Optionally, enter a description for the lookup. This description is for reference only and is not displayed in the lookup.
6
Enter the starting row and the number of lines to display in the browse pop-up window.