How can I associate a relational table with a database?

Relational tables must be associated with a database for the data in them to become available to the email template.

Procedure

  1. Create a new database, or select an existing database.
  2. In Data, go to View Data or Manage and click the database name. The Data Summary displays.
  3. Click Associate Table. The Associate Relational Table dialog box displays.
  4. Select a relational table from the database and click Select. The dialog box changes to a field selector to select and map the fields.
  5. Select a field to use from the Data Fields.
  6. Select a field to use (map to) from your Table Fields and click Map.
  7. To add additional fields, click Add an Additional Field Mapping.

    The Data Fields selectors reappear.

  8. When mapping is completed, click Submit and submit the data job.

Results

The field data selected is available to templates that use this database. You can use the data for personalization in both the header settings and body.