print multiple child table line items

[Cortical]

Hi,

FM10A mac/win (fms10 on OSX)

The requirement is to print a report that details the parent and all related child records for mutiple child tables

A parent table (patients) has multiple child line item tables ( patientdoctors, patientnurses, patientlocations...) and the number of line item records per child table can vary per parent record.

Several approaches, each presents issues.

1. mulitiple sub summaries I can not get to work

should this approach work?

2. parsing the respective line data into a variable presents too many issues with output column alignment; is tedious but plausible

3. printing a pdf using append, with a different layout/TOC for each child table works, but the pages do not 'roll up' ; the content should flow on, as it is I get a new page for each append. t Am I missing something trivial here?

A simpleprint output is the preferred result, no pdf to delete…

the output should be structured:

patient

names, dob, age ...

patdr

A drname

B drname

C drname

...

patlocn ward bed

1 q

2 r

3 s

4 t

5 u

6 v

...

patnrs

1 nrsname

2 nrsname

3 nrsname

4 nrsname

5 nrsname

...

[comment]

See:

http://fmforums.com/forum/showpost.php?post/271539/

[Cortical]

thanks