AnsweredAssumed Answered

Newbie Help - Generate mailing letters

Question asked by IanStone on Mar 26, 2009
Latest reply on Mar 27, 2009 by IanStone

Title

Newbie Help - Generate mailing letters

Post

I have 2 tables.  Table 1 is called Projects and contains the following 2 text fields (Simplified):

 

Project_Name

Project_Address

 

Table 2 is called vendors and contains detailed information of all bills paid to each vendor by project.  Field definition as follows (again simplified) 

 

Project_Name  (Text field)

Vendor_Name (Text field)

Bill_Amount (Numeric field)

Total_Billed  (Summarizes total of bill_amount)

 

Sample of records in table 2 may be (formatted Project_Name, Vendor_Name, Bill_Amount)

 

Project1, ABC Company, 200

Project1, DFE Company, 850

Project1, ABC Company, 340...

 

I have defined a relationship between the 2 tables linking the Project_Name field and generated a layout that summarizes the activity by project.  A typical result is

 

Project1

ABC Company $540

DFE Company $850

Project1    $1390

 

Project 2

 

and so on

 

I would like to use this result set to generate a form letter that goes something like this

 

Congratulations <<Vendor_Name>> you spent <<Total_Billed> on <<Project_Name at <<Project Address>>

 

I can generate both the result set (in a layout) and the form letter but I can't figure out how to relate the result set to the form letter without exporting the data and creating a new table which seems superfluous.  

  

 

Any help would be greatly appreciated. 

 

 

Outcomes