I'm having a problem and I don't know where to start to solve it. Perhaps you guys can give me a start:
I want to make a report that lists families that are bounded to our organisation. The layout is as following:
lastname, firstname_man + firstname_women street zipcode city phone
name of kids, separated with comma's
And now with real names:
Duin van der, Tom + mariah 34 Blackstreet 1430AD Amsterdam 020-5372545
Yudith, Anna, David
The first line is not the problem, that's already programmed. But how do I get the names of the childen on one line?
I have a table tbl_person that holds a p_id, first_name, and a family_id and some other stuff about a person.
I also have a table tbl_family that holds the family_id, familyname, etc
in a normal query, I do: select firstname from tbl_person where family_id = [family_id]
in the example above, I get 3 rows of names:
Yudith
Anna
David
how can I get it displayed in one row? like:
Yudith, Anna, David??
I want to make a report that lists families that are bounded to our organisation. The layout is as following:
lastname, firstname_man + firstname_women street zipcode city phone
name of kids, separated with comma's
And now with real names:
Duin van der, Tom + mariah 34 Blackstreet 1430AD Amsterdam 020-5372545
Yudith, Anna, David
The first line is not the problem, that's already programmed. But how do I get the names of the childen on one line?
I have a table tbl_person that holds a p_id, first_name, and a family_id and some other stuff about a person.
I also have a table tbl_family that holds the family_id, familyname, etc
in a normal query, I do: select firstname from tbl_person where family_id = [family_id]
in the example above, I get 3 rows of names:
Yudith
Anna
David
how can I get it displayed in one row? like:
Yudith, Anna, David??