Drill-Downs

Drill-downs are generated by using the query in the column DrillDownSQL. In general, the query is similar to the query in BRPass1SQLString.

To isolate the drill-down to a particular value by which to filter the data (the value in the KeyField column in tblBusinessRules), the query contains additional conditions in the WHERE clause of the SQL statement. The following is an example from a customer-related business rule addition:

((CMA_Organization.ContactIndex) = Forms!frmTemplateDrillDown!txtMasterLink);

This statement replaces the Forms!frmTemplateDrillDown!txtMasterLink with the value in the business rule that represents the row selected by the user, in this case, the contact index. The resulting SQL statement is run and the result set is placed in the drill-down form.