subreport not displaying fields

[JohnLute]

I have two tables with the following fields to report:

tblProfiles
txtProfileID (PK)
Description
Type

tblPKProfilesAssociations
txtProfileID (PK)
ProfilesAssociations (PK)
Quantity
Comments

tblProfiles is related to tblPKProfilesAssociations in a one-to-many
relationship and functions as something of a bill of material. This is a
tricky design. tblProfiles houses many types of entities that can relate to
each other. Hence the one-to-many relationship: one txtProfileID may relate
to many txtProfileIDs.

Now that you have the pertinent table design background; here is the
pertinent report design:

I have a subreport:
srptProfilesAssociations
RecordSource:
SELECT tblPKProfilesAssociations.*, tblProfiles.Description,
tblProfiles.Type FROM tblProfiles INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.txtProfileID;

My rptFinishedGoods uses this subreportwhich is linked:
Link Child Field: tblProfilesAssociations.ProfilesAssociations
Link Master Field: tblProfiles.txtProfileID

When I run rptFinishedGoods everything is fine except that the following two
fields do not display:
tblProfilesAssociations.Quantity
tblProfilesAssociations.Comments.

When I run srptProfilesAssociations all fields display. Only when I run
rptFinishedGoods do the two fields not display.

Do you see anything in the design that’s causing the fields to not display?
I can’t seem to work this one out. Any help would be greatly appreciated!

THANKS!