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?