HCL TECHNOLOGIES ABOUT US PRODUCTS & SOLUTIONS RESOURCES CONTACT US

Home
IBM Distributed Marketing Corporate Marketer's Guide
Form Editor
The Form Editor creates and edits template components. Forms capture information about the List, On-demand Campaign, or Corporate Campaign.
Single Select Database
Single Select Database (SSDB) gives you the ability to create single select drop-down attributes that are based on database tables.
Single Select Database Attribute Reference
A Single Select Database Attribute Reference (SSDAR) represents a single property (column) from a row in the lookup table that is used by the parent SSDOR attribute.

Single Select Database Attribute Reference

A Single Select Database Attribute Reference (SSDAR) represents a single property (column) from a row in the lookup table that is used by the parent SSDOR attribute.

Selection of the lookup table is automatic, depending on the parent SSDOR selected. The lookup table for an SSDAR always points to a parent lookup table.

Use the following conventions while you create SSDAR attributes.

The form must have at least one SSDOR attribute.
Select the parent attribute carefully, and the lookup table is populated automatically.
Give intuitive names to attributes to easily map the attribute to the database column.
By default, SSDAR is a read-only attribute.

The parent lookup table must have a unique key in the table. The unique key must be made the attribute key in the Form Editor as well. The parent key column should be present in the child attribute lookup table.