OK Based on Pat Hartman's many-to-many example (my apologies, Pat,I'm not a good pupil!)
I have three tables -
Communities with CommID, Community;
HealthProblems with HealthProbID, HealthProb;
and a link table with CommFKID and HealthProbFKID.
I have a query, qryCommunitytoHealthProb which...