Main Report Records

[Scott]

I have a main report that has a subreport on it; I want
the main report to display *only* those records who have
a match in the child field on the subreport, is there any
way how to get it.?

Thanks


Scott

 

[Pieter Wijnen]

Sure thing
Create the Recordsource Query like this:
SELECT .... FROM MAINTABLE A WHERE EXISTS (SELECT 'X' FROM SUBTABLE B WHERE
B.LINKFIELD = A.MASTERFIELD)

HTH

Pieter