Value List Limit???

Tables: Company and Contact

Form: Contact Entry Form

Goal: Provide end-user with a drop-down of Companies entered into the Company Table.

After making the Field a COMBOBOX, and the ValueList drop-down began to work, I only received only 502 of the 1602 Companies in the Company table. Is this a bug or is there a limitation to the amount of records a drop-down list can have?

All the best,
Dean

DeanEBedford:
Tables: Company and Contact

Form: Contact Entry Form

Goal: Provide end-user with a drop-down of Companies entered into the Company Table.

After making the Field a COMBOBOX, and the ValueList drop-down began to work, I only received only 502 of the 1602 Companies in the Company table. Is this a bug or is there a limitation to the amount of records a drop-down list can have?

All the best,
Dean

I submitted a solution having the same problem to the dev team a week ago. They told me the bug will be corrected very soon.

Servoy release 1.2 rc6 has a dbvaluelist limit of 500 items … for more items we suggest to use a formDialog instead of valuelist on combobox due to performance.

We are seeing the very same combo box limit in versions 2.2.2 and 2.2.3.
Is there a projection when we might see a version without this limitation?

Do users really want to scroll through 500+ items on a Combo-box? I would have thought this was more a GUI issue than ComboBox limitation.

Jan’s suggestion of putting a list/table on FID would enable the data to be presented in more intuitive format - the list could then be filtered with A…Z buttons or whatever is appropriate to speed selection. IMHO :)

Graham Greensall
Worxinfo Ltd

Do users really want to scroll through 500+ items on a Combo-box? I would have thought this was more a GUI issue than ComboBox limitation.

You know, you’re absolutely correct.
But, one thing is important here - if Dan has a requirement to deliver a combo box entry component, then that’s what he must do. So, from that perspective, his request is a valid one.

I accept that it may be a valid request - but feel that sometimes clients need to be ‘educated’ on the range of presentational options that we have with Servoy. The chance of a User mis-selecting from a 500+ item list is much higher than if the data is filtered and presented in a sortable table.

People do get into a comfort zone with existing software and put up with all sorts of limitations just because they’ve got used to it. We have a chance to help them ‘see the light’ :)

Regards

Graham Greensall
Worxinfo Ltd

I just created a quick & dirty form (v3.1), with combo boxes, and sure could have used a higher limit. One value list has about 1500 values

Can anyone point me to an example of some work-arounds? just for ideas, e.g. form in dialog, etc

thanks
greg

PS
I just tried a text field, with value list attached. This appears to work, filtering the drop list as you type, but double click to select is clumsy