Combobox does not show all records??

Hi Folks

Probably being a dumb a** again but I cant fathom why my Combobox will display only a limited number of records.

Its using a valuelist on a single column and displays (possibly the Foundset Limit of 200) records but nothing like the possible several thousand Distinct data set that could be in the table.

I recognise that there is a limitation on the foundset size but assumed that the valulist would update when the 200th records was displayed and refresh the Combobox? Is thre another technique I can use to populate this Combobox?

If I used SQL to populate the valuelist would this allow a larger display number in the Combobox?

Appreciate feedback.

Hi Ian,

Servoy value lists are limited to 500 items. If you want to display more then you should use a list/table view in a Form In Dialog instead.
Like a FID where the user can filter the list with a search field. It’s a much better (G)UI than a HUGE value list.

Hope this helps.

ROCLASI:
Hi Ian,

Servoy value lists are limited to 500 items. If you want to display more then you should use a list/table view in a Form In Dialog instead.
Like a FID where the user can filter the list with a search field. It’s a much better (G)UI than a HUGE value list.

Hope this helps.

I see your point Robert - thats where I was heading when I realised this would be limiting! Thanks.