AnsweredAssumed Answered

Calculated Field from two tables, How do I?

Question asked by bokenrosie on Feb 26, 2014
Latest reply on Feb 27, 2014 by philmodjunk

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,

Outcomes