Multiple option on field setup for Dropdown

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
DeanAtWork
User
Posts: 32

Multiple option on field setup for Dropdown

Post by DeanAtWork »

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.


arbei
User
Posts: 9286

Post by arbei »

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


mobhar
User
Posts: 11660

Post by mobhar »

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.


Post Reply