I have this nagging requirement that is causing me FITS!



Please tell me you have a suggestion to help me.



Here is the business requirement at a high level.



I have three combo boxes



1. Department

2. Project

3. Task



Box 1 Has around 900 possible choices.



After you select Box 1, Box 2 should populate with matching key records.  

Total Projects = 12,000.  



After selecting Box 2, Box 3 should be populated with matching key 

records, Total Tasks = 77,000



Now if you pick a department, you usually get back just a few dozen 

projects, (same on the tasks) - 



Total records in this table: 105,000+ records.  So pulling all the data 

onto the form is impossible.  I am on a Intranet based app, so ActiveX 

controls is acceptable.  I've been playing around with Infragistics 

Ultragrid trying to solve the problem, but Im not too sure about it.



I'd like to be able to query the data in increments without reloading the 

page (because I could have up to 12 of these three boxes on a screen)



Any ideas?



Lost in Kentucky

Chris

thetemples@y...