Filter parent data by child data? (1 Viewer)

[Bobadopolis]

All,

Is it possible to filter parent records by child records (or subdata) without showing multiple instances of the parent data in the form/query?

Cheers,

Bobadopolis

 

[namliam]

Yes it is...

You can use a sub query to filter the PK of the records you are searching for and show the parents...

 

[Bobadopolis]

Thanks

Got it!

Took me a little while to figure out I had to change the context - I was using "=" before the subquery which didn't work, but changing this to "In" did it!

Thanks namliam