Dropdown with large data sets

Scriptcase 9 General
#1

Good Day,

I’m very new to Scriptcase and am looking at it for a few apps. One of the main goals will be as an external BI type system that pulls data from our ERP system or to provide READ ONLY access into our ERP system after hours.

One specific scenario requires a user to select a product code from a drop down (or similar) list which will then be used to display a grid of stock values. Simplistically, a user will be entering a product code to find out which branches around the country have stock of that code.

The challenge is that we have upwards of 400,000 thousand product codes - how can I minimize the load on the combobox or use an alternative approach? The grid will initially be empty and must only populate once a product has been selected.

Any suggestions will be most welcome

Regards

Campbell

#2

How about a search application before the grid just to limit the number of items?

#3

you can make another search field before this one. for example category. when a user selects the category you can do an onchange on this field that shows your products_code field already filtered by the first field. that way the product list is a lot less