2 Replies Latest reply on Aug 11, 2011 4:35 PM by philmodjunk

    2 "body" parts possible? -- Print a List of names, then a series of container images

    firth5

      Title

      2 "body" parts possible? -- Print a List of names, then a series of container images

      Post

      I have an asset database.

      Table 1 -- Episode

      Table 2 -- Design Names per episode 

      Table 3 -- Design Images

      Each are joined by unique ID keys.

      Thus Episode 1 is linked to multiple designs names.  The Design images are stored (via supercontainer) in a separate table.  The current, approved design will be linked to the design name.  If a design image appears again in episode 2, we simply re-link it via the ID key.

      ------------------

      Here's what I want to do.

      Every day, send a PDF of new designs to our producers for approval.  They want the format to be thus:

      * Cover sheet with a list of the design names

      * Each additional page will be one image for them to review.

      I'm not sure how to achieve this.  It sounds like I want the impossible:  2 "body" parts.  The first part would be just the design names.  The second part would be the design name AND the linked container field.

      Perhaps it's possible for the list of design names to be a portal in the Title header?!?, and the Body would be a list of the container fields? (thus, the base table would be Table 3)

       

      I look forward to your thoughts.  Thanks in advance.