When a text box is based on a FlowField, a drill-down button (o) is automatically attached to the text box. When you click this button (or press SHIFT+F6), the transactions that are used to calculate the value of the FlowField are displayed.

Example

In the chart of accounts, you can execute a drill-down function in the Net Change field. The FlowField summarizes transactions in this account.

The General Ledger Entries window opens and displays the result of this drill-down.

The drill-down feature is provided when a text box is directly related to a FlowField. To get this feature, you need to define DrillDownFormID, either at the table level or at the form level. For more information about defining the DrillDownFormID, see Defining a Lookup Form in How to: Define the Table Relation.

Drill-downs resemble lookups in many ways, and allow you to do most of the things that you can do with lookups. One exception is that drill-downs only apply to FlowFields, which have to be defined when the table is designed.

Customizing Drill-downs

You can customize a drill-down in the following ways:

  • You can disable the drill-down by setting the DrillDown property for the text box to No.

  • Text boxes based on the same FlowField will have different drill-down forms if you define separate DrillDownFormIDs at the form level.

  • You can decide whether the drill-down button should be displayed permanently or only when the text box has the focus. This is done by setting the PermanentAssist property for the text box. Yes means that the button is always displayed, and No means that the button is only displayed when the text box has the focus.

  • You can change the drill-down behavior by writing C/AL code in the OnDrillDown trigger of the table field or in the control. In this case you have to run a form explicitly from your trigger code.