Report with Fields from 2 Related Tables shows incorrect Summaries
I’m sure the answer to this is simple, but I can’t seem to figure it out:
I have two tables CLAIMANT and CLAIM, which are related using 2 fields, MATTER and CLAIMNUMBER. A single claimant can only be in 1 claim, but 1 claim can have multiple claimants.
The CLAIMANT table contains the field for FullName (which is the only field I am interested in from this table for this report)
The CLAIM table contains fields for
- Claim Number (Number Field)
- TotalNumberOfClaims (Summary Field)
- TotalPaidOutOnClaim (Number Field)
- TotalofTotalPaidOutOnClaim (Summary Field)
- TotalClaimants (Number Field)
- TotalofTotalClaimants (Summary Field)
If I run a report showing records from the CLAIM table (subsummary when sorted by Claim Number, Trailing Grand Summary with TotalofTotalClaimants, TotalofTotalPaidOutOnClaim, Total number of Claims), I get the correct information for all the CLAIM table fields, but it only displays 1 claimant leaving the others off the report.
If I run a report showing records from the CLAIMANT table, I get all of the Claimants listed, but none of the Trailing Grand Summary CLAIM fields are correct.
What can I do to get the correct information from both tables in the same Report?