Razzak, Great, that will help me focus on what to do to make this work! The multi-select is really a cool feature so I want to make sure I can get this working. :) Thank you! Diane In a message dated 11/9/2009 6:07:37 P.M. Central Standard Time, [email protected] writes:
At 05:28 PM 11/9/2009, Diane DeMers <[email protected]> wrote: >Has anyone had good experiences using a Variable Lookup List View >on a large table (say over 30,000 records) doing a multi-select? >When I create a Variable Lookup List View control on a form for a >large table, it can take 3 or more minutes to display the table >when the form is initially opened. Is the Variable Lookup List >View just meant for smaller tables or queries/filters that >effectively limit the number of records displayed when the form >is opened? Diane, Bringing up over 30,000 records up-front without a WHERE clause in a ListView is probably not a good idea. The best approach to take advantage of Variable Lookup List View would be to use a dynamic WHERE clause that will only bring up the matching records. Then you can do what you need to do including the option to Multi-Select list item(s). In a situation like yours, the startup Variable Lookup ListView screen should be an empty list to start with. After typing a keyword or defining the selection criteria, you can dynamically build a WHERE clause that will populate (REFRESHLIST) the matching items in the list. To understand these techniques, take a look at your 2009 SAT Sample Applications, specifically the following: http://www.RUpdates.com/SAT2009_RBG9/ 01. Designing Search Screens using OnKeyPress Option (List View) 02. Managing ListBox and ListView Items 03. Using Images in ListView Controls 04. Using Multi-Select Variable Lookup ListViews 05. Cascading ListViews Hope that helps! Very Best R:egards, Razzak.
