C
chgocoach
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?
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?