DBList and multiple selection
Posted on 2000-05-09
I wrote an application where the user can select zip codes (both canadian and US), and I have a dblist listing all zipcodes for a given country, so the user can choose one or more of them. But I have had many demands to allow MULTIPLE SELECTION (like when u click on a line and the scroll down and click another one with SHIFT pressed so ALL lines between both lines clicked become highlited).
After some research on the net (here and elsewhere), it doesnt seem possible to do this with a DBLIST, only LISTBOX. (I am using RDO so I cant use datalist). I know I could manually populate a LISTBOX but there are OVER 700 000 zip (postal codes) in canada! It doesnt seem practical/efficient to populate a LISTBOX with so many records.
Does anybody have a solution to this? Thanks in advance.