Creating A Family Report

[Guest]

I work for a child welfare agency and am trying to develop a DB to track the
children we serve. I am trying to create a report to show each child's basic
information, including siblings. In order to do this, I created a subtable
to link each child to a family unit. I then used that to create a family
unit subreport, listing all the members of each family unit. I linked it to
the main report, but the problem is, the child's name shows up on the
subreport, so it looks like there are two children in the family with the
same name, even though it's the same child being listed once on the main
report and then again in the subreport. How can I filter the subreport so
that the child's name does not show up as a sibling on his/her record? Or,
alternately, is there a better way to create a report of each child and their
siblings?

 

[Joseph Meehan]

I work for a child welfare agency and am trying to develop a DB to
track the children we serve. I am trying to create a report to show
each child's basic information, including siblings. In order to do
this, I created a subtable to link each child to a family unit. I
then used that to create a family unit subreport, listing all the
members of each family unit. I linked it to the main report, but the
problem is, the child's name shows up on the subreport, so it looks
like there are two children in the family with the same name, even
though it's the same child being listed once on the main report and
then again in the subreport. How can I filter the subreport so that
the child's name does not show up as a sibling on his/her record?
Or, alternately, is there a better way to create a report of each
child and their siblings?

I am not sure what you are doing, but see if this idea helps:

Have one family table, and one or more tables for individuals. To make
things easy let's assume any one child would belong to only one family at a
time. All the children would be in the second table linked to the first
table in a one to many relationship. Maybe you have it set up this way, but
I was not sure from the term "subtable"

With this arrangement you should not have a difficult setting up reports
and forms.

Note: depending on your needs information on "parents" may be in the
child table or their own table or in the family table.