Inquiry Drill-Down

This screen allows you to define specific fields in a nominated Inquiry View such that, within the View, you can drill down on the field and display another Ostendo Screen or Inquiry View showing the specific data.  Two tabs are available:

To Screen: Allows you to identify the Screen to which you are drilling down

To Inquiry: Allows you to identify the Inquiry to which you are drilling down

'To Screen' tab

Entry and Display fields

Inquiry: From the drop-down list select the Inquiry Screen to which this drill-down is being associated.

Module: From the drop-down list select the module where the screen to be displayed from the drill-down is located

Screen: From the drop-down list select the screen within the above module to define the screen to be displayed from the drill-down

Linked To: From the drop-down list select either Header or Lines to denote which part of the Order is being enquired upon. 

Screen Field: From the drop-down list select the Key field in the referenced screen.  This is the field against which the Inquiry Drill-down data is matched

Tab Index: Enter the number of the screen tab that will be displayed in the drill-down.  This is usually:

  0 = The List View of the data (Example: Sales Order List View)

  1 = The Main Data View of the data (Example: Sales Order Header Detail)

  2 = The Order Line View (Example: Sales Order Line information)

Inquiry Field: Identify the specific field in the Inquiry Screen that will be compared to the Drill-down screen.  You should note that this is the Query Identity of the field.  If you have renamed the field in the Inquiry Query then that name should be specified here.

'To Inquiry' tab

This screen enables you to link a defined Inquiry Screen to other Inquiry Screen(s).   When using the Inquiry Screen you can 'right mouse' to display the available 'Drill Downs' (as defined in this screen).  Selecting a Drill Down will take you to that Inquiry Screen.

Entry and Display fields

Inquiry From: From the drop-down list select the Inquiry screen against which this drill-down is being added.

From Field: From the drop-down list select the field from the 'Inquiry From' screen from which the Drill Down Value is passed

Linked To: From the drop-down list select either Header or Lines to denote which part of the Order is being enquired upon.  Note: Some Inquiries do not have the Header/Lines relationship.  In this instance select 'Header'.

Inquiry To: From the drop-down list select the Inquiry screen to which you are drilling down to.

To Field: From the drop-down list select the field in the 'Inquiry To' record is being compared against the 'From Field value

'To Script' tab

This screen enables you to link the defined Inquiry Screen to a Script.   When using the Inquiry Screen you can 'right mouse' to display the available 'Drill Downs' (as defined in this screen).  Selecting a Drill Down will run the Script.

Entry and Display fields

Inquiry From: From the drop-down list select the Inquiry screen against which this drill-down is being added.

Linked To: From the drop-down list select either Header or Lines to denote which part of the Order is being enquired upon.  Note: Some Inquiries do not have the Header/Lines relationship.  In this instance select 'Header'.

Script To: From the drop-down list select the Script that will be run when this is selected in the Inquiry Screen

Buttons

Close: This will close the Inquiry Drill Down screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

Add: This will send the cursor to a new line for entry of a new Drill Down record

Save: This will save the current data without exiting the screen

Cancel: Any changes made since the screen was opened or the last time the ‘Save’ Button was pressed will be lost.

Delete: This will immediately delete the current Drill Down record from this list