>You can do all that in the VFP9 Report Designer/Preview. You'll have to write your own drill down code though.

How do you perform a drilldown in report preview?
I have never been able to figure that out, is there a way to know the current row? because as I see it drill down means that the data entry screen should open the record in modify mode from your last detail report.