>I have a parent table and 9 child tables. All of my tables I have create have parameterized local views where I can pass parent table id to child tables id and view information in grid format on my screen. I now want to print a report of a specific record in parent table and all 9 child tables that have records matching the parent id = child id. How do I create a complex report like this in foxpro? Suggestions appreciated
>
>thanks
>Nick Patel
Nick
Have you a view that encompasses all 9 kid tables at once? If so, use this view (or create an SQL select equiv. in your report-calling app.) as the basis of the report.
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
