2 Replies Latest reply on Sep 22, 2016 9:58 AM by user27070

    Print Layout

    user27070

      I'm Trying to create a print layout which contains data from 3 separate tables.

      For example,

      Main form (which holds the main record), LineItem Attachments (can hold 1-10 records) and LineItem Addons (can hold 1-10 records)

      However whenever I create a print layout all I can do is access records from one of the lineitem tables.

       

      Is this because I must have all the LineItem Items in the same table for the print layout to work?

       

       

      Any help would be great!

      thank you!

        • 1. Re: Print Layout
          ErikWegweiser

          Greetings.

           

          I will 'assume,' at least for now, that you already have relationships between your Main Form table and the two other tables, LI Attachments and LI Addons.

           

          Ordinarily if you were doing something like printing an invoice with line items (only one related table), I would recommend the common practice of printing from a layout based on the line items.

           

          Not knowing anything other than what you've described, including that the related records are limited to 10 each, I would say you could create a print form, based on the Main Form table, that contains two portals showing related records from the other tables.

           

          To answer your question, basically 'yes.' So if the above solution doesn't work, you might consider consolidating (if possible) the two LI tables into one. Each record of the LI table would have some field that indicates whether it is an Attachment or an Addon. Then you would print this report as a list view of the Line Items table -- possibly with summary parts separating the two types of Line Items with headers, subtotals, etc. AND that would allow you to have more than 10 instances of each.

           

          Is this clear?

          Good luck.

          • 2. Re: Print Layout
            user27070

            Awesome thank you Erik,

            It makes perfect sense, I will have to re-construct my table design to get everything to work together.

             

             

            Again thank you for your quick response