MikeInMI

I have a database for our homeowner's association with lots of information that works very well, but have run into a problem when trying to print a directory of members. Most of the directory information is in the MAIN table; however, there is a second CHILD table with an occurrence for each child that resides at the address listed in MAIN. There is a sub-summary section when sorted by address, where I print all of the information listed in MAIN, and then I list the CHILD information in the body. I want an occurrence of the body to print for each CHILD associated with that street address. When I go to create the layout, on the first screen it says "Show records from". If I pick "MAIN", the report looks fine EXCEPT it will only print one CHILD record regardless of how many CHILD records are associated with that address. If I pick "CHILD" as the table that is the basis for the report, everything works just like I want it to EXCEPT residents that have no CHILD records associated with their address don't have their MAIN information printed/included in the report. I've been trying to research how to do this, but having trouble even figuring out what search terms to use to look this up. Any thoughts are appreciated.

Thanks, Barbara.

I want to thank bcooney as I now have resolved my problem. His response had me start doing research in the sub-summary area and I was able to find an article that was the key. Evidently, my field which wasn't printing in the sub-summary area was "touching" the header area. By moving it down a couple of pixels, the problem was resolved. Maybe that is weird, but I found an article on it and it worked.

Thank you for the response. The primary table is sorted in order by the key sub-summary field, which is a project number. That is printing fine in the sub-summary area. The field that is not printing is the project description field, which is in another table. I've also sorted that by project number, but I'm led to believe that the order of the related table is less relevant. The relationship of the primary table to the related table is many to one.

FM Pro 11, Snow Leopard I created a sub-summary report and in the leading sub-summary area I am trying to display a field from a related table. In Form view, the field displays fine. When I click on the icon for list view, the field won't display at all. I'm going crazy trying to figure this out.