Name: 4-26-query.PNG Views: 13 Size: 15.3 KB ID: 45087" class="thumbnail" style="float:CONFIG" />
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: