Link Child / Master Fields

[Guest]

I have a subreport with the record source:
SELECT tblProfilesRevisions.txtProfileID,
tblProfilesRevisionsProfiles.txtProfileID,
tblProfilesRevisions.EffectiveDate, tblProfilesRevisions.IssueNumber,
tblProfilesRevisions.Revision, tblProfilesRevisions.Status
FROM tblProfilesRevisions LEFT JOIN tblProfilesRevisionsProfiles ON
tblProfilesRevisions.numProfilesRevisionsID =
tblProfilesRevisionsProfiles.numProfilesRevisionsID
WHERE (((tblProfilesRevisions.Status)="Approved"))
ORDER BY tblProfilesRevisions.EffectiveDate DESC;

This returns the desired data.

My challenge is setting the Child?master links in the main report. The main
report queries the field txtProfileID which needs to be the Master Link
however this leaves me with two Child Links:
tblProfilesRevisions.txtProfileID
tblProfilesRevisionsProfiles.txtProfileID

I've tried linking these in the main report however when both are made as
Child Links then the subreport returns null.

Can I make both Child Links? If so how can I do this?

THANKS!!!

 

[tsawner]

I was just dealing with this problem. Try using a UNION ALL and a
hidden field

See this link...

http://groups.google.com/group/micr...bb/2a8a729ffa513933?lnk=raot#2a8a729ffa513933