Hi, Razzak, Thanks so much, I came to the same conclusion after I posted the e-mail, when I was just going to sleep. There's always more than one way to solve a problem and I need to remember that. Essentially I have a variable lookup list view; the user can display a number of records in the list view based on selection criteria; the user selects some or all records and based on the selection, another form is displayed showing one record per form. It's possible that the user selects a large number of records (but not likely). Thanks again, Diane DeMers [email protected] DeKalb, IL
In a message dated 1/22/2010 11:24:02 P.M. Central Standard Time, [email protected] writes: At 11:24 PM 1/22/2010, [email protected] wrote: >I have a table with about 30,000 records and an AUTONUM field called "seq#". > >I am using a SELECT command to generate a list of seq#s: > >SELECT (LISTOF(seq#)) INTO vlist IND vind from TABLENAME where &vwhere Diane, Just curious ... What are you trying to achieve with the huge list of SEQ#s, separated by comma, in one big string? Did you know that you can PROJECT a TEMPORARY table with just one column to store those SEQ#s, and then do what you have to do with that list of SEQ#s. Hope that gives you some blue's clues! Very Best R:egards, Razzak.
