Given this many to one relationship, I want to create a query that will select 5 of the records from tblRMAs where "status" is equal to "x", but show all of the related partsReturned connected to those 5 records. Currently when I use "Top Values" in the query, it limits the results to 5 records total - so if some RMAs have more than one related record, I don't get 5 RMAs selected, or I may only get some of the partsReturned selected, giving me incomplete data.
Any ideas how to accomplish this?
Here's the query design: