Filtering Listboxes

Hi,
if you need to select 150000 records for a lookup box, this process will take a long time anyway, so there is no workaround for this.
It's not clear what you mean by "filtering" records.

Please clarify.

Hi,
By filtering, I mean dynamic drop down based on previous field choice.

For e.g. I use five listboxes.

The first listbox search for unique values in the lookup table of 150000 records.

The second listbox should eliminate the choice to 20000 records and the third to fewer etc. With the third listbox, the performance is not acceptable already.
I don't know if I should divide the lookup table into 6 lookup tables.

If I do this, will each listbox still link to the previous field choice of another lookup table?
Regards,

Johan

I see what you saying.
Currently dependent dropdown functionality is handled via Javascript on client's side.

This method is very fast for small and medium-sized lookups, but is not suitable for really large ones.
The pages built with PHPRunner can be modified to handle dependent dropdowns by PHP on server side to support very large lookup boxes. This task requires some custom programming.

However we don't have a ready to go solution for this.