W
WDSnews
I have a people table containing parents and children. There is a
"Relatives" table defining the relationship between people in the people
table. The goal is to create a query that produces one record per name in
the People table, and a field containing the concatenated first names of all
the relatives. How can I concatenate child fields?
|People| |Relatives| |People|
ID|--->> PeopleID|
RelativeID|---> ID|
"Relatives" table defining the relationship between people in the people
table. The goal is to create a query that produces one record per name in
the People table, and a field containing the concatenated first names of all
the relatives. How can I concatenate child fields?
|People| |Relatives| |People|
ID|--->> PeopleID|
RelativeID|---> ID|