I hope I can explain this well enough to get a few good suggestions.

I have have Contacts stored in a table (7000+)records and they have medical records another table (4000+) records, not all contacts have medical records but some have multiple

There is a subset of 500 contacts that our lab is interested in looking at in more detail. But for reasons I'm not 100% clear on the lab can not see personal info so they have give me a list of "Sample Numbers" and I've imported those into a separate table (which maybe I don't need but its there if i need it) called Report.

I need to grab list of all medical records associated with each contact that is in my list that comes from the table Report.

In list view can I use a leading grand or sub-summary to show me all related medical records for the sample # in my reports table?

I so hope that did come across a gibberish.

Go To Related Records with the "[x] Match all records in current found set" option checked.