[AccessD] Report/Sub report question.

Hi Jim,

The two reports pull different data based upon a tier code.  The primary
report pulls data for tier 0, and the sub report pulls data for tier<>0.
The reason I need to do it this way is that the report is required to show a
different subtotal for the tier 0 records and one total of all of the
records for the tiers under that one tier.  Note that there can be many tier
0 records.  The tier 0 records are primary contractors and the tier<>0
records are sub contractors under that contractor.

When you say that the field needs to be visible, are you saying visible on
the report or available to display on the report (IE. in the query)?

Hope I haven't confused everyone even more.  LOL.

Thanks,
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson
Sent: Monday, March 24, 2003 9:18 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Report/Sub report question.


Bobby,
It seems to me, there is a normalization problem.
Sub reports/forms are used to display a one to many relationship.  If "the
main report and sub report ... pull from the same table" that indicates a
one to one relationship and there is no need for a sub report.

To insure a sub report works correctly, the common field between the main
report and sub report needs to be visible to both.

HTH
Jim