Multi-select database attributes

You may want to define an attribute that allows the user to choose multiple values from a valid list of options. For example, when specifying the products for a particular marketing campaign for a bank, you might want to select all of the following:

1-year CD

5-year CD

Bank Credit Card

You can accomplish this by creating an attribute with a type of Multi-Select—Database. Creating a multi-select attribute is similar to creating a single-select, with some additional setup.

This attribute type is not available for campaign or cell attributes.

When you create a multi-select database attribute, you must specify the lookup table, and other information as described in Single-select DB attributes.

When creating multi-select database attributes, keep in mind the following restrictions:

The value in the Attribute Database Column Name field needs to 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 additional display options:

Field	Description
Multi-Select Join Table Name	The name of the join table to use for this attribute. Every multi-select database attribute must have a unique join table.