Reporting records that have no table records.

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!
 
D

Duane Hookom

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.
 
G

Guest

Thanks, Duane! I have very little experience in building reports and this
never occurred to me.

Thanks!!!
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top