www.hkvforums.com

Im trying to setup a feild so when searching you can use select multiple values. This works for all my other drop down lists, but the option in the feild setup for to allow multiple values is not there. Can anyone explain why this would nnot be avaiable. This feild looks up its values from a 2 column table where ID is the Key and a second column is displayed to the user with a text description in it.

Double check the field data type is "varchar" or "string".

DeanAtWork wrote:
Can anyone explain why this would not be avaiable

If your field type is numeric or integer, then the "Multiple" option will not be available. The main reason for this is since the multiple values will be saved into that field as a comma separated value. Numeric field cannot be used for such value. That's why your field type must be in string or varchar or char.