Text-multiple field - Maximum input values
For the field type called Text-Multiple Choice, how many values can be stored in the Input Type when the "From List" is selected? Is there a maximum noted anywhere as I'm not finding it. Not sure if...
Forum Discussion
If you are concerned about the number of options; instead use a table to house your list of options. Make the Key Field the field-value; and this can then be connected by relationships anywhere across your Application. The advantage/benefits of this are that you can add other characteristics about the field value option that can be used in your relationships; and you get the use of Summary fields to tell you where those options are used.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
Thanks. Mostly you gave what I was looking for. Seems there is no real max, but it will affect performance, so it's best to generate a "best practice" when deciding on the number of values you add into this field compared to using a table relationship instead.
------------------------------
Ryan
------------------------------
------------------------------
Ryan
------------------------------