Create the Sub Table Template File

Create a new template file for the information extracted from the sub table. When the connector runs the fetch task, this template is combined with the main template and used to generate a single document for each row returned from the main table.

To create the sub-table template file

  1. In a text editor, create the sub-table template for data extracted from the Customers table:

    Name: <!--Title--> <!--FirstName--> <!--LastName-->
    Address: <!--Address1-->, <!--Town-->, <!--Postcode-->

    When the connector generates documents, each HTML comment in this template is replaced by data extracted from the corresponding column in the Customers sub-table.

  2. Save the template as customers.tmpl in the connector's installation folder (this was the file name you specified in the configuration file).