Using query like source for masses emails

[Alogon]

Suppose a query with Field A and A1, A2, … are its values; Field B and B1,
B2, …
In a record, A1 could be associated with B1 and with B3 in another record;
A2 could be associated with B2, B5 and B8 in others records…
Suppose A Field like Customers Field. I want to email A1 and mention (in
this email) all B values associated with A1 value. And so makes the same for
all A values.
How can I do that?

 

[Piet Linden]

Suppose a query with Field A and A1, A2, … are its values; Field B and B1,
B2, …
In a record, A1 could be associated with B1 and with B3 in another record;
A2 could be associated with B2, B5 and B8 in others records…
Suppose A Field like Customers Field. I want to email A1 and mention (in
this email) all B values associated with A1 value. And so makes the same for
all A values.
How can I do that?

use fConcatChild from www.mvps.org. It will collapse the many side of
the query into a single field.