Re: Connecting to the Same Table Twice

Tech-Archive recommends: Fix windows errors by optimizing your registry

well, reports are not my strongest area - i can usually figure out how to
get what i want after some fiddling, but not efficiently enough for me to
give very good suggestions in a newsgroup forum. i might start by building a
query based on tblChild and either one of the other two tables, linked on
the ChildID pk/fk fields. since both are "child" tables, to its' "parent",
probably doesn't really matter which child table you choose. base the report
on that query, grouping on the ChildID field. build a subreport based on the
third table. the main/sub reports will also be linked on the ChildID pk/fk
fields.

suggest you give it a try; then if you run into problems, post a specific
question in the microsoft.public.access.reports newsgroup for more (and
better) help than i'm likely to offer. include some specific information re
the table relationships, the report setup, and the specific problem you're
having - to help people help you.

hth


"Joy M" <ab520@xxxxxxxxxxxxxxx> wrote in message
news:lJ0le.36314$Ph4.728636@xxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi there -
>
> Thanks, tina, for your input. You saved me a lot of (my precious
valuable)
> time!!
>
> OK, another question, if you would be so kind. I think I know what to do,
> but I would like your approval.
>
> The report should look like this --
> Info from tblChild
> Info from query tblChild tblRelationships tblAdult
> Info from query tblChild tblClass
>
> The way I see it -
> the basic child information,
> all his relationships (e.g. parents, nanny, emergency contact, doctor)
> the child's schedule of classes (they may go 3 mornings a week or 5
> afternoons etc.)
>
> So...question is...
>
> Can I put these 3 reports into one. I am pretty sure I can, but I have
> never done it before. I think I read about it somewhere.
> (All I have done before is make reports from 1 table or a header table and
a
> details table.)
>
> I think all the info would fit onto one page, but I see the info comes
from
> 3 different sources. What is the best way of doing this?
>
> Thanks !!! !!!
>
> Joy
>
>
>
>
>
>


.