I tried the EnableAutomaticLoadonDemand technique and it works basically well. One thing though, I thought it was supposed to cache the full result from the database if I set EnableItemCaching. I ran a SQL Profiler trace and it reruns the query each time, which causes slowness in non-local situations. The combo does need to post after the user selects something, so the app can continue with the selection they chose. Is there something else I need to do?
Thanks.