2 Replies Latest reply on Feb 27, 2014 6:56 AM by philmodjunk

    Calculated Field from two tables, How do I?

    bokenrosie

      Title

      Calculated Field from two tables, How do I?

      Post

           I thought I had made things "cleaner" by moving all of my formatting segments to a separate table but now I cannot assemble my document into a calculated field.  I have some sample table and data below.

           My goal is to assemble the notice by combining the fields from each of the tables.  So I would take: Table2::Section1&Table1::IssueName&
           Table2:Section2&Table1::ParAmount&
           etc.

           When all done it would the notice together with the dynamic content that changes.

           I have two tables:

           Table 1:Notice Information (Sample field Data) I collect via a form)
           -IssueName (Borough of Shrewsbury)
           -ParAmount (
           -SaleDate

           Table2:Formatting Sections 
           -Section1(<tbody>

           <tr>
           <td class="eeb_width" style="width: 558px;">
           <div class="ee_editable eev_element" style="width: 558px; position: static;">
           <div style="text-align: center;">
           <div style="margin: 4.5pt 0in; line-height: 13.5pt;"><font style="font-family: tahoma, geneva, sans-serif; font-size: 18px;"><b><font style="color: rgb(0, 0, 0);)

           -Section2( </font></b></font><font style="color: rgb(51, 51, 51); font-family: tahoma, geneva, sans-serif; font-size: 14px;"><br><br></font><font style="font-family: tahoma, geneva, sans-serif;"><b><font style="color: rgb(0, 90, 149); font-size: 16px;">$12,025,000*</font></b><br><font style="color: rgb(0, 0, 0);"><b><font style="font-size: 16px;">Sales Tax Revenue Refunding Bonds, Series 2013</font></b></font></font><font style="font-family: tahoma, geneva, sans-serif; font-size: 14px;"><br><br></font><font style="font-family: tahoma, geneva, sans-serif; font-size: 14px;"><b><font style="color: rgb(27, 15, 151);")
           -Section3, 

           Thanks,