Bob, You can create a temp table from your master table, with an additional autonum column. Then return that column.
Jan -----Original Message----- From: Bob Thompson <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 6 Nov 2014 11:16:49 -0600 Subject: [RBASE-L] - Re: Control options The variable list view was my first choice, but I am not seeing how to determine what the desired item index value would be. When I call the control, I know that I need item "x" preselected. The item number is alpha numeric field. So item "595A" may be the 632nd item in the sorted item master field. I do not see how to obtain the value 632 before calling the list control. Thanks, Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Nov 6, 2014, at 10:43 AM, "A. Razzak Memon" <[email protected] [mailto:razzak%40rbase.com]> wrote: > At 11:22 AM 11/6/2014, Bob Thompson wrote: > >> I need suggestions on what form control to use to select a record >> >> Requirements: >> Control must handle 2000+ records >> >> Display two columns >> >> Have a predetermine record already selected and high lighted in >> the proper list order. >> >> Display 15 records in a scrolling region >> >> Example: >> >> 123. Test >> 124. Testa >> 125 Testb >> 126. Testc >> 127. Testd >> Etc >> >> I need record 126 pre-selected/highlighted with >> the ability to select any other record in the 2000+ item list >> >> So when the control is called, it may need to start the display >> at record 900 - 915 and have the ability to scroll forward or >> backward > > Bob, > > There are so many ways to accomplish such task. > > 01. Use Enhanced DB Grid Control and then use the "JUMPTO" > property to select/highlight the record as On After Start > EEP, if you wish. > > PROPERTY TABLE <FORMTABLENAME> 'JUMPTO' > > 02. Use Variable Lookup ListView with pre-selected record value > as Key Field. > > 03. Use Variable Lookup ListView with added "Show Row Number" > with pre-selected record value as Key Field. > > Let me know if you need a sample form(s) to illustrate the use > of such cool features in R:BASE eXtreme 9.5 (32/64) for Windows. > > Feel free to reach out to me with any questions. > > Very Best R:egards, > > Razzak. > > www.rbase.com [http://www.rbase.com/] > www.facebook.com/rbase [http://www.facebook.com/rbase] > -- > 31 years of continuous innovation! > 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! > -- > >
