>Ok - riddle me this,
>
>How can I get a report to print with a parent record and multiple-table child records? For example, suppose my parent table is "Person" - a person can have children and/or pets. How can I get the report to print something like this.
>Of course any given person may have any number of pets or children or none or some of both or either (wow- that was mouthful). I'm playing with various joins to see if I can come up with something the report writer can deal with. Any ideas?
Ken, the way I would solve this probelm with FoxFire is to create two function s (PERSON_PETS() and PERSON_KIDS()) which return character strings filled with the names of the pets or kids, respectively. Foxfire will wrap the output down the page within the print positions I define for that print element.
Peter Robinson
Peter Robinson ** Rodes Design ** Virginia