Main Report Records

S

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
 
P

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
 
Top