By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Report Creation Problems

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <ma*******@byu.edu> wrote in message
news:c4**************************@posting.google.c om...
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?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.