Printing multiple child databases in one document

[mattr]

Hi all! How do I print a proposal having multiple line-items and multiple attachments? The line-items and attachments are in separate child databases (P_Line_Items.fp5 and P_Attach.fp5, respectively). The attachments are all 1-page container fields and require page-breaks between each one.

By printing from the P_Line_Items database I can get the proposal line-item table and body to slide/print nicely. How do I get the 1-page attachments (container fields) to print after the line-items?

In the past, I have printed in separate print sessions... not nice for faxing or emailing!

[danjacoby]

It occurs to me that, if there is one attachment per line item, you could create a relationship between P_line_items and P_attach, and then place the related container field in the line items layout (no portal, just the related field). This way, you get one line item along with its related attachment just by printing from the Line Items file.

[mattr]

Thank you for responding! You're right, i could print P_attach from P_line_items, but I would end up with LineItem1, Attachment1, LineItem2, Attachment2,... I would prefer to have the lineitems grouped in a table at the beginning of the proposal, followed by the attachments. The attachement may be many to one, by the way.

I'm thinking now that I may need to have a separate child database for printing that stores reference to each line-item and attachement. Then I could print in any order I want. ... need to think on it some more. I will let you know if I have a breakthrough!

[danjacoby]

You might be able to use tiny subsummary parts to separate the groups. Of course, you still need to sort in such a way as to create the groupings you want.