Abacus 21 Report-Designer (SDK) has the ability to create Sub-Tables. The following example illustrates the setup and use of Sub-Tables.
Illustration: Use of Sub-Tables to create multiple links from one Primary File to the same Look-Up File (without its getting confused)
Report: Member Type Change Audit Trail
Lookup Table: Membership-Types
Problem: From the Member-Type-Audit Table, need to look up both the From-Type and To-Type Descriptions.
Solution: Create two Sub-Tables for the Member-Types file:
Sub-Member-Types-From (with a Relation to Member-Type-Audit)
Sub-Member-Types-To (with a Relation to Member-Type-Audit)
The Report Desired (Excerpt) -
The Primary Table
The Table that needs to be linked to (multiple times in the same Report) -
Creation of the Sub-Table
Sub-Tables that were created (from the Membership-Types Table)
Example of the From Relation Link
Sub-Table Lookups in the Report
