Reporting records that have no table records.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that queries 4 tables:

tblProfiles
tblPKCGPhysicalAttributes
tblPKCGMaterialAttributes
tblPKCGFinishingAttributes

tblProfiles is in a one-to-one relationship with the other tables with
txtProfileID being the primary key.

The report is a specification sheet. My challenge is that not every
txtProfileID record will have data in tblPKCGFinishingAttributes. Because of
the design, these records won't display in the report.

Is there a way I can have every txtProfileID record display regardless if it
has a record in tblPKCGFinishingAttributes?

Thanks!
 
Only place the tblProfiles in the report's record source query. Place all
related tables/records in subreports. It could be that you already have this
type of solution set up with forms and subforms.
 
Thanks, Duane! I have very little experience in building reports and this
never occurred to me.

Thanks!!!
 
Whooops. Something's not right. I created rptPKCorrugated and placed
tblProfiles in the record source query. I then made a
srptPKPhysicalAttributes and placed it in the detail of the report. The Link
Child Fields and Link Master Fields are properly assigned to txtProfileID,
however, when I go to view the report the subreport doesn't display - only
it's label does.

Any ideas?

Thanks!
 
Back
Top