Multiple-Select - Database attribute types

You can define an attribute that allows the user to choose multiple values from a valid list of options.

For example, when users specify the products for a particular marketing campaign for a bank, they can select one, two, or all of the following options:

  • 1-year CD
  • 5-year CD
  • Bank Credit Card

To offer multiple selection in a field, you use an attribute with a type of Multiple-Select - Database. Creating a multiple selection attribute is similar to creating a Single-Select attribute, with some additional setup.

Note: This attribute type is not available for campaign, cell, or offer attributes.

When you create a Multiple-Select - Database attribute, you must specify the lookup table, and other information as described in Single-Select - Database attribute types.

When you create Multiple-Select - Database attributes, keep in mind the following restrictions:

  • The value in the Attribute Database Column Name field must be unique across attribute categories. (You cannot use the same database column name for both a grid attribute and a form attribute.)
  • You must not change the data type of the key column after you create the attribute.

You must also specify the following display option.

Table 1. Option for Multiple-Select - Database attributes
Field Description
Multi-Select Joint Table Name The name of the Joint table to use for this attribute. Every Multiple-Select - Database attribute must have a unique Joint table.