| re: Report Creation Problems
You embed a separate Report in each Subreport control... and each Report
will have its own Field List. There won't be, and I am not sure how you'd
expect to use, a "consolidated" field list for the main report and all
subreports.
Larry Linson
Microsoft Access MVP
"Mark Lees" <mark_lees@byu.edu> wrote in message
news:c4f3d99f.0401291424.6cdadf59@posting.google.c om...[color=blue]
> I need to create a report based on 4 tables
> 1. tbl_KidsList
> 2. tbl_Sub_Address
> 3. tbl_Sub_Phone
> 4. tbl_Sub_Parents
>
> Tables 2-4 are actually subforms that are placed upon the KidsList
> form.
>
> The report will list the kids name, addresses, phone numbers, and
> parents.
>
> Questions
> 1. How do I add all the tables to the report so all the fields will
> be listed in the fields list?
>
> 2. I guess I have to connect or join the tables via the client ID so
> all of the data will be listed in one instance. How do I do that?[/color]
| 
