Use "Go To 'All' Related records - in the Join table" from your committee table. Then do your standard Join Table report.
You can also do the committee search, then perform a GTRR to the related Members table at a Member list layout, using the members-based layout for the report.
That has the limitation of being a bit harder to display if you need a sorted list by Committee where some members may be on multiple committees. In that case you will need a list report layout for the join table so that a single member can be listed under multiple committees in the report.
The natural thing for them to do is to go to the Committees layout, and perform a find on the committee name.
You could also do the find on the related committee name, while you are in the CommitteeMembers join table. This would find all join records related to the 6 commitees in your example.
Alternatively, find the matching committees, then perform Go to Related Record [ CommitteeMembers; Match found set ]. However, this will be slower. IMHO.
(The join table doesn't have a layout, at least not yet!)
How do you produce your report, then?
Message was edited by: Michael Horak