Reports with multiple relationships

I've got a table with two one-to-many relationships with other tables. When I try to design a report with all the info from the main table and the two "sub" tables, I get repeats of alot of the data. I've tried selecting the "Hide Duplicates" property for these fields in the report design view, but it doesn't work. Any suggestions?

Thanks

That will happen unless there is some join field between the two "sub"
tables. You will probably have to create 2 sub-reports and place them on the
main report.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Elizabeth" wrote in message
...
I've got a table with two one-to-many relationships with other tables.
When I try to design a report with all the info from the main table and the
two "sub" tables, I get repeats of alot of the data. I've tried selecting
the "Hide Duplicates" property for these fields in the report design view,
but it doesn't work. Any suggestions?

Thanks