>I have three tables that I want to report against. The relationship is parent to child to grandchild. What is the best aproach for me to take to design my reports to show all records? I don't want to write a seperate report for each relationship...

You will want to get all the data into one cursor then make your report from that. Then using the grouping feature if necessary.

Does that help?